Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking for a way to run 1 job, but multiple (50+) times each with a different set of (5) context variables. I would like to have an excel sheet that looks like below which later we will be able to add to or remove from that's in a central location and easy for the entire team to get to in order to update. I don't want to have to setup 50+ jobs in the TAC job conductor so I'm trying to loop through the excel sheet and run the job 1 time for each row, placing the row_values into the 5 context parameters then on to the next row when the previous job is complete. I've tried a few different things and was hoping someone may have done this before or knows a way to accomplish what I'm asking. Thanks in advance!
Col_1_Name | Col_2_Name | Col_3_Name | Col_4_Name | Col_5_Name
--------------------|-------------------|-------------------|-------------------|------------------
row1_value1 | row1.value2 | row1_value3 | row1.value4 | row1_value5
row2_value1 | row2.value2 | row2_value3 | row2.value4 | row2_value5
...
row50_value1 | row50.value2 | row50_value3 | row50.value4 | row50_value5
Hello,
You could put all context group you need and use tContextDump to create your config file (used to name Config.ini).
Here is the related component reference about:TalendHelpCenter:tContextDump. Let us know if it helps.
Best regards
Sabrina