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 want all rows which do not have null for Column2 to be deleted.
Technically speaking, I want something similar to:
myTable2 = Table.SelectRows(myTable1, each ([Column2] = null))OR
myTable2 = Table.RemoveRows(myTable1, each ([Column2] <> null))which are of course not valid M, since both Table.RemoveRows and Table.SelectRows don't work like that.
So my question is, how could I achieve something like those above?
Thanks a lot in advance!
Got it.
Still do what I suggest, but change the generated M code from:
[Column2] <> null and [Column2] <> ""
to:
not ( [Column2] <> null and [Column2] <> "" )
3 Replies
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.