Remove rows based on blank cells of a column

[third_hicana]

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

[BA_Pete · Accepted solution]

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

[third_hicana]

@BA_Pete

Thank you very much