Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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

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