How to extract a row with empty value from Excel?

[rp2018]

We are trying to extract data from Excel *.xlsx file using tFileInputExcel component.

1st column with empty value is not getting extracted even though 2nd column has value.

Is there anything in Talend we can do to extract all of the data?

Here is the sample data:

[Anonymous]

@Ranjan Patel​ , the rows should be extracted even though one of columns has empty value. What is the output you get?

Regards

Shong

[rp2018 · Accepted solution]

Had business fill in values in the 1st column and it worked.