topic Re: tContext Load From SQL Query in Talend Studio

tContext Load From SQL Query

Anonymous — Sat, 16 Nov 2024 13:24:57 GMT

I would like to set a context variable from a SQL Query.
Here is what I have
MSSQLInput -> tMap -> tContextLoad
In the map I map
MSSQLInput - Last_Id variable to a variable in tContextLoad called Contact_Id
When I execute I receive multiple errors about key values
Should I do this a different way?

Re: tContext Load From SQL Query

Anonymous — Mon, 31 May 2010 06:34:18 GMT

Hello
The schema of tContextLoad is fixed, it has two columns key and value, so you should map the two columns on tMap, define two columns: key and vlaue, set the expression of key column as: "Contact_Id", set the expression of value column as "row1.Last_id" //row1 is the flow name.
Best regards
Shong

Re: tContext Load From SQL Query

Anonymous — Tue, 04 Oct 2011 22:09:34 GMT

I would like to use a context variable from contextLoad into oracleInput query.
I can see teh key-value pair for tContextLoad. the value I need to use in sql query. How can we use the contextLoad value in a query?