Reading Multischema .xls file using tFileinputExcel component

_AnonymousUser — Fri, 13 Jan 2017 13:43:56 GMT

Hi,
I am facing an issue while reading data from multiple sheets of a .xls file.The tab/sheets are having different metadata or column definitions, so we are selecting the option "All sheets" in tFileinputExcel component.But we end up with having data in the output, only up to the first sheet's columns.
The scenario is : in a excel file we have three tabs - in tab1 we have 3 columns,in tab2 5 and in tab3 10.My desired output is all the columns appended from all the sheets, irrespective of the metadata.The sheet names are not known and header names are also unavailable.We are simply feeding random number of hedaers(100 columns) for metadata of tFileinputExcel component.
We can achieve the required output if the source file extension is : .xlsx but not for .xls.
Any suggestion on this?

Re: Reading Multischema .xls file using tFileinputExcel component

Anonymous — Mon, 16 Jan 2017 02:25:20 GMT

Hi,
If the sheets have all the different structures, you need different flows to read your excel file by using tfileinputexcel component.
So far, there is no "Dynamic schema" feature in tfileinputexcel component.
Best regards
Sabrina

topic Re: Reading Multischema .xls file using tFileinputExcel component in Talend Studio

Reading Multischema .xls file using tFileinputExcel component

Re: Reading Multischema .xls file using tFileinputExcel component