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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema