topic Re: how to save a value from table to context variable in Talend Studio

how to save a value from table to context variable

Darmesh — Wed, 13 Jun 2018 06:56:33 GMT

Hi,

I have a value in my table as

name

xyz

how to store the value xyz to context variable. so that we can use it for further use.

manodwhb — Wed, 13 Jun 2018 07:16:41 GMT

@Darmesh,you can load to context using tContextLoad and check the below link to more about tContextLoad.

aashish_21nov — Wed, 13 Jun 2018 07:37:34 GMT

With the help of tjavarow component, you can do so.

So, your job would be like :

tmssqlinput-->tjavarow

In tjavarow write below code.

context.var = input_row.name;

Darmesh — Wed, 13 Jun 2018 08:11:26 GMT

first i have created context variable as var and did not enter anything in value column.

But it is not loading anything.

aashish_21nov — Wed, 13 Jun 2018 09:32:51 GMT

@Darmesh you should write input_row.column_name rather than row4.column_name.

Darmesh — Fri, 15 Jun 2018 07:11:09 GMT

still i am getting null value.

aashish_21nov — Fri, 15 Jun 2018 07:20:31 GMT

System.out.println(context.var);

TRF — Fri, 15 Jun 2018 07:22:10 GMT

Setting a value to a context variable will not change what you can see into the Context tab, it changes only the current value for the runing job.

Darmesh — Fri, 15 Jun 2018 07:28:19 GMT

I got the result. But when i am passing that context var vaule to tmap. i am getting only "Quarterly Estimates" and not the variable value.

aashish_21nov — Fri, 15 Jun 2018 07:32:17 GMT

use below code in tJavarow:

context.var = context.var+row4.newColumn ;