Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Remove unwanted rows

Hi,   I have created a sample data in which column Id has values like underscore (_), (null), (blank) etc. (refer rows 5 to 8 in attached file).   I understand there is an option "Remove Empty" w...
Need Help
Show and Tell
Tips and Tricks
  • Baskar's avatar
    Baskar
    7 years ago

    Anonymous

     

     

    Add those two lines in your Power Query. 

     

    Text1 = Table.SelectRows( Text, each [ID] = Text.Select([ID],{"a".."z","A".."Z","0".."9"} ) ),
    #"Filtered Rows" = Table.SelectRows(Text1, each [ID] <> "")

     

  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    You should be able to click on the drop down arrow of a colum and remove values that you do not want (uncheck) and those rows should get filtered out.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

You should be able to click on the drop down arrow of a colum and remove values that you do not want (uncheck) and those rows should get filtered out.