Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
Thank you!
Andreea
Hi Andreea,
I hope I understood it correctly, I just made my own example.
I have created a table "Queries" that contains in one column the queries
Then I have a table "Table A" with the values I query.
The Job design looks like this
I load the table with the queries, the tMap_2 is just assign the field to the next component (if you would have more fields in the query table) after that its going into a tFlowToIterate and then to the table which contains the data you want to query. The rest is easy just another tMap to Map the fields and then a tUnite to unite the data into one stream into TableB.
Here is the important stuff on the query config in TableA (you need to assign the variable from the tFlowToIterate component:
I hope that is what you were looking for.
Cheers
Ben
Thank you very much!