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.
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")