Iterate through Excel rows and run sub-job for each

Highlighted
One Star

Iterate through Excel rows and run sub-job for each

I am looking for a method of using a tFileInputExcel component to read rows from an excel file each of which will contain a start and end date. For each row I want to populate 2 context variables and run a subjob which will use these values. I am a bit of a Talend beginner and not quite sure how to do this.
Highlighted
One Star

Re: Iterate through Excel rows and run sub-job for each

Give this a try:
tFileInputExcel --row1--> tFlowToIterate --Iterate--> tRunJob
in the tRunJob you can pass the values sent to the tFlowToIterate by using the following code:
globalMap.get("row1.columnName")

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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

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