how to save a value from table to context variable

[Darmesh]

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]

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

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/xH2TyYr_AmQnKwOYlqVCvA

[aashish_21nov]

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]

@aashish

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

But it is not loading anything.

[aashish_21nov]

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

[Darmesh]

@aashish

still i am getting null value.

[aashish_21nov]

System.out.println(context.var);

[TRF]

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]

@aashish @TRF

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 · Accepted solution]

use below code in tJavarow:

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