I have an Excel with data, having below structure.
Name Phone Email
ABC 9123456789 ABC@gmail.com
and in another Text file (structure.csv) I have the "Excel structure" as
Is it Possible to read the Excel file, by using the "Excel structure"(structure.csv) present in Text file ?
without hardcoding the schema in the tFileInputExcel component by referring the "structure.csv" file .
As there may be different structure for different excel with metadata present in Text file.
Can this be achieved in Talend open studio (Free version)
But the structure of Excel would be present in .csv file to refer
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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