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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Izhar_Firdaus
Contributor
Contributor

How to call variable from tgeneratorRow using tSystem

Hi Talend,

I am currently trying to iterate a list of tables name and pass the value to tSystem component which the tSystem will run a spark job based on the table name. My idea is: tRowGenerator (list out the table) --> tSystem (run the spark job based on the listing table). However, when I tried this way, the tRowGenerator unable to pass the tSystem, which I believe it requires an correct variable to be called. My question is, how can I iterate in tsystem and what is the correct variable should i call in tSystem?

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

You can use tForEach component to iterate each table name from pre-defined list, and you can access the current table name with global variable.

((String)globalMap.get("tForeach_1_CURRENT_VALUE"))

View solution in original post

2 Replies
Anonymous
Not applicable

Hi

You can use tForEach component to iterate each table name from pre-defined list, and you can access the current table name with global variable.

((String)globalMap.get("tForeach_1_CURRENT_VALUE"))

Izhar_Firdaus
Contributor
Contributor
Author

@Shicong Hong​ yeap manage to iterate each table name thanks!