topic Re: take a value from a sql table and save it in a variable in Talend Studio

take a value from a sql table and save it in a variable

Gabri11 — Thu, 27 Dec 2018 10:21:01 GMT

Hi, I should extract a value from a table and save it in a variable and then use it in a subsequent query. I'm a beginner. Can someone good-hearted help me? 🙂

Re: take a value from a sql table and save it in a variable

krengan21 — Thu, 27 Dec 2018 10:48:23 GMT

Hi,
You can use globalvariable to get and put in a query as mentioned below
1.Use tsetGlobal varaible component
2.In tsetGlobal variable assign value and name to that global variable
3.Use global.get("name assigned in the tsetglobalvariable")
4.To get as a string use (String)global.get("name assigned in the tsetglobalvariable")
Let me know on any queries

Regards,
Kasthuri Rengan

Re: take a value from a sql table and save it in a variable

Gabri11 — Thu, 27 Dec 2018 11:21:13 GMT

Thanks for the reply. As I said, I'm a beginner. I have a scheme as below but talend says:

"MaxDate cannot be resolved to a variable"

Cattura.JPG

Re: take a value from a sql table and save it in a variable

akumar2301 — Thu, 27 Dec 2018 12:21:10 GMT

put it in double quotes "MaxDate"

Re: take a value from a sql table and save it in a variable

Gabri11 — Thu, 27 Dec 2018 12:42:00 GMT

Ok but...

I have this situation:

1: I run the first query:

"SELECT
max( PUB.uoggetto.dtvartime) as MaxDtvartime
FROM PUB.uoggetto"

2: I would like to save a MaxDate variable

3 run a new queri using the variable

"SELECT
*
FROM PUB.uoggetto

where dtvartime = 'variable' "

Re: take a value from a sql table and save it in a variable

krengan21 — Thu, 27 Dec 2018 12:49:20 GMT

Hi ,

Can you show me the screeshot of tsetglobalvariable component?

Regards,

Kasthuri Rengan

Re: take a value from a sql table and save it in a variable

Gabri11 — Thu, 27 Dec 2018 12:52:31 GMT

Re: take a value from a sql table and save it in a variable

krengan21 — Thu, 27 Dec 2018 12:55:21 GMT

Hi ,

Use (Date)globalMap.get("MaxDate")) expression in the query .

Kindly accept this as solution

Regards,

Kasthuri Rengan

Re: take a value from a sql table and save it in a variable

Gabri11 — Thu, 27 Dec 2018 12:59:53 GMT

the problem is in the error above. "MaxDtvartime can not be resolved or is not a field" at setgloablvar

Re: take a value from a sql table and save it in a variable

akumar2301 — Thu, 27 Dec 2018 13:08:47 GMT

define schema in tMysqlrow where schema column name same as query result column name.

during select use GlobalMap get methode.

Re: take a value from a sql table and save it in a variable

akumar2301 — Thu, 27 Dec 2018 13:11:54 GMT

Define schema in tMysql row where schema column name same as query result column name.

during select use GlobalMap get

Re: take a value from a sql table and save it in a variable

Gabri11 — Thu, 27 Dec 2018 13:16:20 GMT

I do not use mysql but a jdbc generic because the source is openedge

Re: take a value from a sql table and save it in a variable

Anonymous — Fri, 28 Dec 2018 05:58:11 GMT

Hi,

I understand that you are trying to get the value for the post mentioned below.

https://community.talend.com/t5/Design-and-Development/Where-clause-dynamic-postgresql-with-date/m-p/146298#M89888

Lets try to do it in slightly different way.

Step 1:- Create a context variable max_date with String data type

Step 2:- Assign the value from database to context variable as shown below. Make sure that your data from database is fetched in the format YYYYMMDD and converted to String. If you want the value in different format, make sure that the format is in sync everywhere.

Now, you have the value in the context variable which can be used in the whole job. Please note that you can use the Global variables also. In that case, you need to assign the Global variable in String format as argument to your next post.

Hope it helped to resolve your issue 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂