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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.