Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

How to remove blank rows from an input flat file?

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...
expression_language
pipeline
transform
  • ddellsperger's avatar
    ddellsperger
    3 years ago

    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.

ddellsperger's avatar
ddellsperger
Admin
3 years ago
Copy LinkReport

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.

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    3 years ago
    Copy Link

    Thank you @pmancevski for your suggestion and assistance on this one. I tested with your solution and unfortunately it didn’t work.