Multiple context parameters in an external file

Six Stars

Multiple context parameters in an external file

Hi,

 

I think my last post was removed or didn't save, but if not I apologize for double posting.  I'm looking to have an excel sheet with 50+ rows, 5 columns where each row is a set of context parameters to be used in a run and each column is a context parameter.   I would like to have a job run 1 for each row and for each of the 5 columns a context variable would be set and used within the run.  I've tried several different things but can't seem to get this working and would love any advice or ideas of how to accomplish this.

 

Thanks in advance!


Accepted Solutions
Highlighted
Sixteen Stars
Sixteen Stars

Re: Multiple context parameters in an external file

Don't worry, my 1rst answer disappear too.

Possible with a parent job to read the Excel file, tFlowToIterate to set global variables from current row then tRunJob to run the job for the current context. You just have to set individual context variable from the corresponding global in the tRunJob settings.

TRF

View solution in original post


All Replies
Highlighted
Sixteen Stars
Sixteen Stars

Re: Multiple context parameters in an external file

Don't worry, my 1rst answer disappear too.

Possible with a parent job to read the Excel file, tFlowToIterate to set global variables from current row then tRunJob to run the job for the current context. You just have to set individual context variable from the corresponding global in the tRunJob settings.

TRF

View solution in original post

Highlighted
Six Stars

Re: Multiple context parameters in an external file

Hi @TRF ,

 

I was able to figure this out, thank you!

 

Used this as a reference: https://help.talend.com/reader/1RJ7TatgS73nP1RPGjT50w/RGvRFDFE3zpmX_rYN63gUw

Highlighted
Six Stars

Re: Multiple context parameters in an external file

 

2019 GARTNER 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

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