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.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.