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.
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.
Last edited by petersenss (2016-09-30 16:44:06)
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.