Forum Discussion

third_hicana's avatar
third_hicana
Icon for Helper IV rankHelper IV
2 years ago
Solved

Remove rows based on blank cells of a column

Hi. Asking for your help regarding transforming my table.

 

I wish to remove blank rows in my table based on blank cells of column 'Talk Title'

 

I tried to modify the code below in power query but an error occured.

 

#"Removed Blank Rows" = Table.SelectRows(#"Renamed Columns3", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}),each try Text.Clean(Text.Trim(_)) otherwise _ ),{""})

in

#"Removed Blank Rows"

 

 

Hoping for your help. Thank you. 

 

-Third

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi third_hicana ,

     

    Are you just trying to remove any rows where [Talk Title] is blank?

    If so, then the following step should work:

    Table.SelectRows(
    PreviousStepName,
    each [Talk Title] <> ""
)

     

    You may need to adjust the "" bit, depending on whether your your non-null values in that column are "", " ", "    " etc.

     

    Pete

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    2 years ago

    Hi third_hicana ,

     

    Are you just trying to remove any rows where [Talk Title] is blank?

    If so, then the following step should work:

    Table.SelectRows(
    PreviousStepName,
    each [Talk Title] <> ""
)

     

    You may need to adjust the "" bit, depending on whether your your non-null values in that column are "", " ", "    " etc.

     

    Pete