Filtering empty column and removing whole rows

[SH_94]

Hi Community,

I would like to ask about the filtering of empty column for specific data header and removing the whole row if the chosen column is empty. 

I have attached file and screenshot below for your reference.From the screenshot below , i want to know if there is empty / blank in the column invoice. If yes, remove the whole row .

May i know how we build the workflow to fulfill this requirement?

[bpatel]

hi @SH_94 ,

you can use the filter tool with IsEmpty([invoice]) to achieve this. 

hope this helps

[SH_94]

Hi @bpatel ,

Thanks a lot for the great sharing.

May i know if we can use formula tool in this case ? Or any other method beside the filter tools?

[justamfam · Accepted solution]

Hi @jacob_94 ,

The data cleansing tool should allow to you accomplish the same thing.

K/R,

JAF