I have multiple sheet in single excel , I have to read header of each sheet.
Please post the solution.
Thanks for replying,
i have tried this option before but it is give header of the 1st sheet, not from all sheets.
Please let me know some other option.
I am not sure about options in tfileInputExcel to restrict header record.
May be you can try with tMap to filter only header record from all sheets.
Here create sequence based on sheet name and filter first record from each sheet.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema