Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Feed tForEach dynamically

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?
Labels (2)
3 Replies
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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.