Forum Discussion

bouyazbekj's avatar
bouyazbekj
Helper I
7 years ago
Solved

Excluding certain items from a column

Hello everyone,   I have a column of item codes and I would like to only see certain ones.    For example I want to only see items that start with an E and B from this column    E0617-0012 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI bouyazbekj,

     

    You can enter to query editor and apply a filter with following custom filter expression:

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Text],"E") or Text.StartsWith([Text],"B"))

     

    Full query:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RcxRCoAwDAPQu+zbQVZp7T5Vxg4xdv9rWGuHf3kkZIzUIOXIQKE0N6fIzwsCNvLHEzu9FHbeIB8Hm6VqxGrBalReV6q51mAnKhztfAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Text = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Text", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Text],"E") or Text.StartsWith([Text],"B"))
in
    #"Filtered Rows"

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI bouyazbekj,

 

You can enter to query editor and apply a filter with following custom filter expression:

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Text],"E") or Text.StartsWith([Text],"B"))

 

Full query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RcxRCoAwDAPQu+zbQVZp7T5Vxg4xdv9rWGuHf3kkZIzUIOXIQKE0N6fIzwsCNvLHEzu9FHbeIB8Hm6VqxGrBalReV6q51mAnKhztfAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Text = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Text", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Text],"E") or Text.StartsWith([Text],"B"))
in
    #"Filtered Rows"

 

Regards,

Xiaoxin Sheng