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
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
Test drive Talend's enterprise products.