skip empty rows from file

[Karuetl]

In a file i receive data as below , need to load only real data and skip those rows are empty with commas acb@gmail.com,super,$0.0,1 def,user,$10.00,0 ,, , ,, ,

[Anonymous]

as per my understanding

in a row , any column contains empty you want to reject that row

if that is the case: check every columns in tMap which is not equal to null, and then at output use a function in tMap with all columns together, and if you want catch rejected rows you can catch them too

[Anonymous]

Hi,

   If you want to skip a row which having only null values, it can be easily achieved while reading itself.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi,

How can we achieve the same for .xlsx/.xls files.

[manodwhb]

@mahadev ,

Stop reading on encountering empty rows in advanced settings of tFileInputExcel.

Select this check box to ignore the empty line encountered and, if there are any, the lines that follow this empty line. This check box becomes unavailable when you select Read excel2007 file format (xlsx) in the Basic settings view.

https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/NbQZuwgNcj_FdUhPpR3dXQ

[Anonymous]

Hi @manodwhb ,

Sorry for the late reply.

This will throw error and stop the entire job, however I just need to ignore/skip these rows and proceed reading the remaining contents of file.

[Samana]

I have the same question.

My job is ending with errors if it encounters empty row. And in my case, there are around 70k records in the file, so after that, its reading empty row and ending with errors.

[Samana]

@Manohar B​ 

If we have checked Read excel2007mfile format(xlsx), how do we achieve this condition?

[gjeremy1617088143]

Hi, maybe you could try a tFilterRow with the lengh of a specific row superior to 0.

Send me love and kudos