Dynamically pass value tSampleRow

Five Stars

Dynamically pass value 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.

Attached :

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]

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog