Multiple Context Groups in one file, possible?

Highlighted
Six Stars

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

Moderator

Re: Multiple Context Groups in one file, possible?

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog