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 q...
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

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