[resolved] Get current Row description from a tFileInputFullRow

Highlighted
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.

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.

All 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!!!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch