Load value dynamically to tSampleRow

Highlighted
Five Stars

Load value dynamically to tSampleRow

I have a input file with 10 columns and a simple tmap which process the 10 columns and send it to tSampleRow where i hardcoded and to output file. It works fine. 

Now i need to change the value of tSampleRow dynamically ( fetch value from database and set in context variable) and use the context variable in tSampleRow.

1. Job

2. ChildJob ( for loading context variable ) which works fine

3. tRunJob

4. tSampleRow

 

Can you help me how to give the value in tSampleRow and What should i assign in tRunJob Context column.

 

Child Job works fine :

System.out.println("hi");

System.out.println(context.rows);

globalMap.put("output",context.rows);

System.out.println((String)globalMap.get("output"));

 

Starting job DatabaseJob at 15:32 03/04/2018.

[statistics] connecting to socket on port 3705
[statistics] connected
tContextLoad_4 set key "days" with value "monday"
tContextLoad_4 set key "rows" with value "5"
hi
5
5
[statistics] disconnected
Job DatabaseJob ended at 15:32 03/04/2018. [exit code=0]

 

Accepted Solutions
Highlighted
Nine Stars

Re: Load value dynamically to tSampleRow

Hi Dinesh,

 

Are you looking for this ?

You need to define context value in DB. like key=rows and value=1..5

assign this using context load in job and use context.rows in tSampleRow.

 

ContextSampleRow1.pngContextSampleRow2.png

Regards,

 

Veeru Boppudi

View solution in original post


All Replies
Highlighted
Nine Stars

Re: Load value dynamically to tSampleRow

Hi Dinesh,

 

Are you looking for this ?

You need to define context value in DB. like key=rows and value=1..5

assign this using context load in job and use context.rows in tSampleRow.

 

ContextSampleRow1.pngContextSampleRow2.png

Regards,

 

Veeru Boppudi

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog