How to call variable from tgeneratorRow using tSystem

[Izhar_Firdaus]

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?

[Anonymous · Accepted solution]

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]

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