Ignore empty rows and continue reading in tFileInputExcel

Five Stars

Ignore empty rows and continue reading in tFileInputExcel

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.
Moderator

Re: Ignore empty rows and continue reading in tFileInputExcel

Hi,
Have you tried to check out option "Trim column" in Advanced settings of tFileInputExcel component?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Ignore empty rows and continue reading in tFileInputExcel

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

Re: Ignore empty rows and continue reading in tFileInputExcel

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
Five Stars

Re: Ignore empty rows and continue reading in tFileInputExcel

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.
Four Stars

Re: Ignore empty rows and continue reading in tFileInputExcel

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