Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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.

View solution in original post

2 Replies
TRF
Champion II
Champion II

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.
Anonymous
Not applicable
Author

Hi @TRF ,

 

I was able to figure this out, thank you!

 

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