talendtalend-mdm

How to read data values from different rows from an Excel file in Talend?


Essentially I just need to have lookup functionality. I need to go row by row and then access values from other rows in my excel document. How can this be accomplished?


Solution

  • You will probably have to use two tFileInputExcel components, and use one as a lookup in a tMap, using Left Join/Inner Join between columns to get your corresponding values.