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

Multiple Context Groups in one file, possible?

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

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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