topic How to set context variables with query result in Talend Studio

How to set context variables with query result

chichibio — Sat, 16 Nov 2024 10:50:37 GMT

Hi at all ,

I've necessary execute 2 query. The first query results is a parameter that I would use in second query.
For example:
1 Query: select max(date) from A
2 query: select count(*) from B where max(date.A) > max(date.B)
I would use max(date.A) like variable, so : Select count(*) from B where "variable" > max(date.B)
How I can do it?
Best regards
thnx at all

Re: How to set context variables with query result

Anonymous — Tue, 26 Jan 2016 10:07:22 GMT

It depends on how you want to use the value, timing, flow vs iterate connections, etc, etc. But as a start I would recommend returning your result from a db input component and then using a tJavaRow component to set the result to a context variable.

You might also want to look at the tContextLoad component as that might solve your problem in an easier way.

Re: How to set context variables with query result

chichibio — Tue, 26 Jan 2016 10:26:09 GMT

rhall_2.0 wrote:
It depends on how you want to use the value, timing, flow vs iterate connections, etc, etc. But as a start I would recommend returning your result from a db input component and then using a tJavaRow component to set the result to a context variable.

You might also want to look at the tContextLoad component as that might solve your problem in an easier way.

It's a simple flow. Nothing else...
Just read from table > put the result in variable and compare with another date from another db and table..finally count the difference of record.

Re: How to set context variables with query result

chichibio — Tue, 26 Jan 2016 15:48:37 GMT

help me !!! please

how I can do it!!thnx