topic Can not read all data of Excel when using Dynamic Schema in Talend Studio

Can not read all data of Excel when using Dynamic Schema

laughsmile — Mon, 15 Apr 2024 05:58:17 GMT

Hello everyone

I am using Talend Data Integration Job to read the following Excel which has 3 rows and 88 columns:

But only part of data(2 rows and 17 columns) can be read, the first row and part of columns lost after read by using dynamic schema.

By the way, if I define 88 string column in the schema , I can read the all data.

Thanks in advance.

Re: Can not read all data of Excel when using Dynamic Schema

Shicong_Hong — Mon, 15 Apr 2024 11:28:07 GMT

The first row should be header, it always be treated as header if you use a Dynamic schema. There may not be enough space to display all columns with tLogRow component, you can output the data to a file to check if part of columns are missing. eg:

tFileInputExCel--main--tFileOutputDelimited.

Regards

Shicong

Re: Can not read all data of Excel when using Dynamic Schema

laughsmile — Mon, 15 Apr 2024 12:31:42 GMT

Hello @Shicong_Hong

Thanks for your answer.

After changing tFileInputExCel's header from 0 to 2 , it can read all columns now.

Best regards.

Re: Can not read all data of Excel when using Dynamic Schema

laughsmile — Fri, 26 Apr 2024 09:31:20 GMT

Hello everyone.

I can read all columns by setting tFileInputExcel's header as 2.

But the first row is skipped after setting tFileInputExcel's header as 2.

How can I get the first row which contains one non-empty cell in the first column.

Thanks in advance.

Re: Can not read all data of Excel when using Dynamic Schema

Shicong_Hong — Fri, 26 Apr 2024 09:46:05 GMT

If you set the header as 2, the first row will be skipped, the second row will be treated as header columns when using Dynamic schema. To read the first row, I think you need to use another tFileInputExcel component to read it with general schema.