topic Re: skip empty rows from file in Talend Studio

skip empty rows from file

Karuetl — Tue, 16 Apr 2019 19:43:00 GMT

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 ,, , ,, ,

Re: skip empty rows from file

Anonymous — Tue, 16 Apr 2019 20:42:34 GMT

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

Re: skip empty rows from file

Anonymous — Thu, 18 Apr 2019 11:20:06 GMT

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 🙂

Re: skip empty rows from file

Anonymous — Thu, 30 Jan 2020 15:39:57 GMT

Hi,

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

Re: skip empty rows from file

manodwhb — Fri, 31 Jan 2020 12:54:31 GMT

@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

Re: skip empty rows from file

Anonymous — Wed, 18 Mar 2020 14:43:13 GMT

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.

Re: skip empty rows from file

Samana — Mon, 04 Apr 2022 08:14:58 GMT

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.

Re: skip empty rows from file

Samana — Mon, 04 Apr 2022 08:16:47 GMT

@Manohar B

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

Re: skip empty rows from file

gjeremy1617088143 — Mon, 04 Apr 2022 09:41:57 GMT

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

Send me love and kudos