Remove all rows if NOT Null

[qinh_ann]

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!

[blopez11 · Accepted solution]

Got it.

Still do what I suggest, but change the generated M code from:

[Column2] <> null and [Column2] <> ""

to:

not ( [Column2] <> null and [Column2] <> "" )

[blopez11]

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. 

[qinh_ann]

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.