topic Re: [resolved] Get current Row description from a tFileInputFullRow in Talend Studio

[resolved] Get current Row description from a tFileInputFullRow

Anonymous — Sat, 16 Nov 2024 12:45:01 GMT

Here is my situation:
I need to read a xls files with different sheet. each sheet has the same structure, but I' don't want all sheet. so I create a file with the name of the sheet that I want to read.
So tFileInputFullRow iterate over the list and tFileInputExcel get the name of the sheet to export to a postgres db.
The problem is that I can't find the way to have the line tFileInputFullRow is reading.
tFileInputFullRow works ok if I send the main to TLogRow. When I connect to tFileInpuetExcel only iterate is possible, that's ok too, but how can I do to know the value (description) that FullRow is iterate?
Thanks in advance.

Re: [resolved] Get current Row description from a tFileInputFullRow

alevy — Wed, 10 Aug 2011 01:21:38 GMT

You need a tFlowToIterate between tFileInputFullRow and tFileInputExcel, which will allow you to put the row value into the globalMap whence you can use it for tFileInputExcel.

Re: [resolved] Get current Row description from a tFileInputFullRow

Anonymous — Wed, 10 Aug 2011 13:22:50 GMT

Thanks alevy, it's work fine!!!