How to remove blank rows from an input flat file?

[darshthakkar]

Hi Team,

How can I remove all the blank rows from an input flat file? I cannot use a condition restricted on a single column as the other records are needed. All I want to do is filter out ALL ROWS that doesn’t have any data (like Row 4, 5, 7, 8 shown in the screenshot below)

Desired Output:

Thus, final output should be:

Thanking in advance.

Regards,
DT

[AleksandarAngel]

Hi @darshthakkar,

After parsing the file try using a filter with the following expression $ != {}.

Let me know if this helps,

BR,
Aleksandar.

[darshthakkar]

Sure @AleksandarAngelevski , I will give it a try,
I tried with isEmpty() both on filter and router but it didn’t work, was planning to put a condition on all the columns as the last resort (but that is not a good design to be honest).

[darshthakkar]

AleksandarAngelevski:

After parsing the file try using a filter with the following expression $ != {}.

This is not fetching the desired results.

[ddellsperger · Accepted solution]

This is maybe a little bit difficult, but you can put the following filter after your parser
The expression is: $.entries().filter(v => v[1] != "").length > 0 which will find any instance where all of the values for the given input document are all empty and filter them out.