loopstext-fileskettlepentaho-spoonpentaho-data-integration
Loop inside Pentaho Data Integration Transformation
I have a transformation as
where the text file is in the following format:
For each of the t_cmp(the number of t_cmp is not known prior) in the text file, I want to execute Read Company
But it is giving error as
Can anyone please tell me where am I going wrong?
Solution
You need to pass 3 rows, each with 1 field, instead of a single row with 3 fields.
The number of fields must match the number of parameters of your query.
So, in short, transpose your data. Either:
- read line as a single field then use Split field to rows
- or read as now and use Row normalizer
Both approaches should work.
- php how to scrape inside <li><a> using simplehtmldom?
- Creating Internal Loops Dynamically
- c - what is the most efficient way to copying a string?
- Create joined string by looping through key value array
- Use of goto to continue from several nested loops C
- For loop to open and access satellite netcdf data
- Subscript out of range error looping through rows and columns in Excel VBA
- Filter array of object with another array of objects boolean property
- Making a Loop function and table in R
- PHP loop is overwriting array
- Trouble Returning to Previous input in loop
- use sed group variable within loop for another grep
- How to duplicate a string 10 times
- How to find all possible ways to divide a string into n slices without recursion?
- modify/create column based on groups defined externally
- Does the inner loop run first?
- How to avoid loop in Pandas iterating unique values?
- Using Conditional Statements in Dymola
- Looping <li> elements in JSX React
- How to iterate through a python list to get each additional list element?
- Find how many times a value appears in a 2D array and store that number in another 1D array
- In java, how would I find the nth Fibonacci number?
- How can I use 2 for loops together (one for each year and one for each day)?
- Matrix indexing/flattening
- VBA find 2nd, 3rd and 4th occurrences if multiple IF conditions met within FOR NEXT loop
- Getting random symbols after trying to replace chars in C++
- How can I close a loop without exiting the 'game'
- print empty asterisk triangle c
- What is the point of adding short sleep to while true loop?
- How do I loop something forever in JS?