Solved: take a value from a sql table and save it in a var... - Qlik Community

Gabri11 · ‎2018-12-27

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? 🙂

Anonymous · ‎2018-12-28

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...

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 🙂

View solution in original post

krengan21 · ‎2018-12-27

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

Gabri11 · ‎2018-12-27

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

akumar2301 · ‎2018-12-27

put it in double quotes "MaxDate"

Gabri11 · ‎2018-12-27

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' "

krengan21 · ‎2018-12-27

Hi ,

Can you show me the screeshot of tsetglobalvariable component?

Regards,

Kasthuri Rengan

Gabri11 · ‎2018-12-27

krengan21 · ‎2018-12-27

Hi ,

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

Kindly accept this as solution

Regards,

Kasthuri Rengan

Gabri11 · ‎2018-12-27

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

akumar2301 · ‎2018-12-27

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

during select use GlobalMap get methode.

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

Talend Data Integration

v7.x