I need to know if the Excel file which is being processed has header names same as per the expected sequence. If the header names are different I need to stop job with an error captured in tLogCatcher. If the header names are same as per the expected sequence then the file is supposed to be processed further.
But tFileInputFullRow works for CSV file for Excel it prints garbage values. Is there a way in Talend to capture all headers of Excel File as a Single Row?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables