Forum Discussion
Remove all rows if NOT Null
Hello everyone, To start, I have a huge table with over 10k of entries, which took form somewhat like this. I need to remove the entire rows on condition based on Column2. Specifically, I ...
Got it.
Still do what I suggest, but change the generated M code from:
[Column2] <> null and [Column2] <> ""
to:
not ( [Column2] <> null and [Column2] <> "" )
I think if you want to remove rows where column2 is null, just select the down arrow icon next to the column2 name, select Remove Empty, then OK.
Hi blopez11 , sorry I wasn't being clear enough 🙂 What I want to do is to delete those rows that do not hold null value for column2. For example, after applying the query, rows 8 and 9 should be deleted while rows 1 to 7 are still in the table.