topic Re: Ignore empty rows and continue reading in tFileInputExcel in Talend Studio

Ignore empty rows and continue reading in tFileInputExcel

Anonymous — Wed, 20 Aug 2014 06:49:17 GMT

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.

Re: Ignore empty rows and continue reading in tFileInputExcel

Anonymous — Wed, 20 Aug 2014 07:59:54 GMT

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

Re: Ignore empty rows and continue reading in tFileInputExcel

Anonymous — Wed, 20 Aug 2014 09:32:51 GMT

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

Re: Ignore empty rows and continue reading in tFileInputExcel

Anonymous — Wed, 20 Aug 2014 09:38:31 GMT

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

Re: Ignore empty rows and continue reading in tFileInputExcel

Anonymous — Thu, 21 Aug 2014 03:50:11 GMT

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.

Re: Ignore empty rows and continue reading in tFileInputExcel

Anonymous — Thu, 21 Aug 2014 09:39:26 GMT

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