Ignore empty rows and continue reading in tFileInputExcel

[Anonymous]

Hi all,
I have an Excel with data and I need to populate the data in to an Oracle table.
But, there are some scenarios where there are empty rows in the Excel sheet.
So I need to skip the empty rows and continue the flow. I couldn't find a configuration
in the component for this scenario. But they have something like 'Stop reading on encountering rows'
which does not help my situation.
Is there any other way to get this done?
Thanks,
thivanka.

[Anonymous]

Hi,
Have you tried to check out option "Trim column" in Advanced settings of tFileInputExcel component?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Yes, my job has already checked 'Trim all columns' option.

[Anonymous]

Can you identify a single unique column to represent a row and use tfilterrow..
or create a crc column based on all columns and filter based on the value of CRC
vaibhav

[Anonymous]

Hi Sanvaibhav,
I dont have a value to identify a column in the Excel file uniquely. I have to generate an ID once I input the row to the database table only. I will try the other option you mentioned.
Thanks,
thivanka.

[Anonymous]

In above case, you will have to identify and note down the value of CRC when all the columns are null... there could be chance that the columns may be blank as well. In this case the CRC value would change... be careful about finalizing CRC value for filtering.
thanks
vaibhav