Using query output as a variable

[Anonymous]

Hi,

I have a Terdata query of count rows from specific table and i would like to use the result of the query as a variable/context afterwards on the Talend job.

How can I do this?

Thanks

[TRF]

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.

[Anonymous]

Can you please elaborate about using this components as I'm not famailier with them?

What should I write in them?

Thanks

[TRF · Accepted solution]

tJavaRow:
context.yourVariable = input_row.yourField;

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

[Anonymous]

"yourfield" should be the column name that i want to use?

[TRF]

Yes

[Anonymous]

Thanks a lot, it worked!