Forum Discussion

umaluagr's avatar
umaluagr
Regular Visitor
2 years ago
Solved

Delete the rows if the value in one column is null

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.

Need Help

3 Replies

  • dufoq3's avatar
    dufoq3
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi umaluagr,

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

     

    • umaluagr's avatar
      umaluagr
      Regular Visitor
      2 years ago

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