One Star

[resolved] Get current Row description from a tFileInputFullRow

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

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

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.
2 REPLIES
Seven Stars

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

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.
One Star

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

Thanks alevy, it's work fine!!!