topic Re: Multiple context parameters in an external file in Talend Studio

Multiple context parameters in an external file

Anonymous — Sat, 16 Nov 2024 04:28:39 GMT

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!

Re: Multiple context parameters in an external file

TRF — Fri, 04 Oct 2019 06:54:21 GMT

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.

Re: Multiple context parameters in an external file

Anonymous — Sun, 06 Oct 2019 15:54:00 GMT

Hi @TRF ,

I was able to figure this out, thank you!

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