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

Question

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?

Answer 1

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.