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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LNUTHALA
Contributor
Contributor

Store Table output in one of the Job and reuse the values across job

Store Table output in one of the Job and reuse the values across job

Labels (4)
1 Reply
Anonymous
Not applicable

Hello,

We are supposing that you would like to use the result of the query as a variable/context afterwards on the Talend job, if so you are able to push the result to a tJavaRow to populate the context variable.

You may also push the result to a tSetGlobalVar if you want to use a global variable instead of a context variable.

tJavaRow:

context.yourVariable = input_row.yourField (for example; the column name that you want to use);

tSetGlobalVar:

Just connect it to the DB component. It will create a global variable for you with a name based on the flow + the field name such as row1.yourField

Feel free to let us know if it helps.

Best regards

Sabrina