topic Re: tFileInputExcel reading all cells as null in Talend Studio

tFileInputExcel reading all cells as null

Anonymous — Fri, 30 Sep 2016 16:17:43 GMT

Hi,
I have a job that takes an input xlsx file and maps it to another file, but in this particular job, the component is not reading my data.

My job skips the 10 row header, as expected, and reads the 88 rows of data, which I can see in the file are not null.

The job reads 88 rows, then my filter removes rows with a null date. This removes every row because the input is reading nulls for every value.

I can't seem to figure out why it's not reading the data, when it can clearly read the file.

Update:
If i manually enter anything into the blank row in the header(row 9 is blank), the job runs properly. I put one whitespace character into a cell on the blank row(I picked column B) and it worked. It seems the null row in the header is causing the component to read all other cells as null.

Re: tFileInputExcel reading all cells as null

Anonymous — Fri, 30 Sep 2016 18:35:42 GMT

what are the settings of your tFilterRow_1? That is where values go in, but they don't come out.

Re: tFileInputExcel reading all cells as null

Anonymous — Fri, 30 Sep 2016 18:36:43 GMT

If you put your tLog before the tFilter, you would see data.

Re: tFileInputExcel reading all cells as null

Anonymous — Fri, 30 Sep 2016 20:07:35 GMT

My tfilterRow_1 is filtering for nulls in one column using basic settings.
I have a tLogRow both before and after the filter, so I can see what the data looks like before and after filtering. Before is the full schema with nulls in every cell, after is empty, 0 rows of data.
Based on the input, the filter is working properly, removing all rows where my chosen column is null. My issue seems to be that tFileInputExcel_2 is not reading data, and is instead reading nulls in every cell.

Re: tFileInputExcel reading all cells as null

Anonymous — Fri, 30 Sep 2016 20:12:10 GMT

I can't share the data, but from this screenshot you can see that there is indeed data in the table. That empty row in the header seems to be the problem somehow, is there a way to remove it and use another input to read the data after removal?