topic Reading Excel file dynamically with metadata present in .csv file in Talend Studio

Reading Excel file dynamically with metadata present in .csv file

Anonymous — Wed, 21 Sep 2016 14:58:35 GMT

Hi Team,
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
Name,Phone,Email

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)

Thanks,
Raj

Re: Reading Excel file dynamically with metadata present in .csv file

Anonymous — Thu, 22 Sep 2016 07:18:10 GMT

Hi,
So far, there is no dynamic schema feature in tfileinputexcel component. Do you want to read a excel file with unknown column structure?
Best regards
Sabrina

Re: Reading Excel file dynamically with metadata present in .csv file

Anonymous — Fri, 23 Sep 2016 14:08:26 GMT

Hi Sabrina,
Yes I want to read the Excel without defining the schema structure.
But the structure of Excel would be present in .csv file to refer .
Let me know if you require any other information.
Regards,
Raj

Re: Reading Excel file dynamically with metadata present in .csv file

Anonymous — Mon, 26 Sep 2016 06:18:03 GMT

Hi Sabrina,
Any updates?

Thanks,
Raj.

Re: Reading Excel file dynamically with metadata present in .csv file

Anonymous — Mon, 26 Sep 2016 07:21:58 GMT

Hi,

But the structure of Excel would be present in .csv file to refer

You have to design your schema structure at design time not run time.
Best regards
Sabrina