Forum Discussion
How to keep all the rows where a specified column is empty
Hello, When I select a column, I can go to the menu "Reduce the rows", then it presents me 2 options : keep rows / remove rows. Within "Remove rows", I have 6 options, including "remove empty rows"....
Ok, I did that but only "remove empty elements" was present, so I inversed the code and it is fine now :
= Table.SelectRows(Source, each [xxx] = null or [xxx] = "")
All GUI features are a front-end for a bit of code. I presume MS will take a view on what they think is useful.
For your case, I think you want to click on the dropdown on the relevant column header. You can filter using one of the choices there. You can also edit the code (once it's in the query steps) and change it if it doesn't quite meet your needs
Ok, I did that but only "remove empty elements" was present, so I inversed the code and it is fine now :
= Table.SelectRows(Source, each [xxx] = null or [xxx] = "")