Delete the rows if the value in one column is null

[umaluagr]

Hi community

I have a table with 20 columns. If the value in column 5 is null I want to delete this row automatically. The table is constantly filled and I want to avoid having those incorrect rows in there. So, IF column 5 IS null THEN delete row. I am sure there is an easy solution out there. I just don't get it.

[dufoq3 · Accepted solution]

Hi @umaluagr,

yes, there is 🙂 Just filter out null value for [Column5]

[umaluagr]

Thank you for the quick help. I was thinking far too difficult. 

[dufoq3]

You're welcome.