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?
Asked
Active
Viewed 222 times
0
-
Does your row have unique key ? – Théo Capdet Oct 06 '20 at 11:34
1 Answers
2
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.
Corentin
- 2,442
- 1
- 17
- 28
-
How does it know which rows to look at in the tMap? I can’t find any examples of this online. – mastercool Oct 07 '20 at 10:12
-
https://help.talend.com/reader/~Dhe9Vej4Bk9zGrBM4kxQA/Nwh5YQ~BB0ASb7v5zl_Wyw – Corentin Oct 07 '20 at 11:45