topic Feed tForEach dynamically in Talend Studio

Feed tForEach dynamically

Anonymous — Sat, 16 Nov 2024 13:10:11 GMT

Hi
I would like to know if we can feed dynamically tforeach based on TMSSqlInput.
1. tMSSqlInput result need to feed the tForEach values ?
2. Could we use a contextvalirable with a list of values for tForEach?

Re: Feed tForEach dynamically

Anonymous — Tue, 28 Dec 2010 10:50:52 GMT

Hi
If you want to iterate the according to the records in the select Query in tMSSqlInput you can use tFlowIterate

Re: Feed tForEach dynamically

Anonymous — Tue, 04 Jan 2011 16:10:53 GMT

Thx Lijo for your response but how do you get the result of the query
exemple
I have a TMSSqlInput with query like "select NAME from clienttable where age <30" I would like to have a messagebox alerte with the response of the query
how do you do?
DN

Re: Feed tForEach dynamically

Anonymous — Tue, 04 Jan 2011 18:30:18 GMT

tMSSqlInput--->tFlowToIterate-->tMessageBox
in the message box, to reference data from your mysql input:

globalMap.get("<row>.<column_name>")

The row varible is the row input to your tFlowToIterate.