topic Re: Using query output as a variable in Talend Studio

Using query output as a variable

Anonymous — Tue, 27 Nov 2018 13:31:41 GMT

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

Re: Using query output as a variable

TRF — Wed, 28 Nov 2018 14:56:23 GMT

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.

Re: Using query output as a variable

Anonymous — Thu, 29 Nov 2018 05:41:44 GMT

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

What should I write in them?

Thanks

Re: Using query output as a variable

TRF — Thu, 29 Nov 2018 06:03:34 GMT

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

Re: Using query output as a variable

Anonymous — Thu, 29 Nov 2018 06:05:44 GMT

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

Re: Using query output as a variable

TRF — Thu, 29 Nov 2018 06:07:18 GMT

Yes

Re: Using query output as a variable

Anonymous — Thu, 29 Nov 2018 06:22:51 GMT

Thanks a lot, it worked!