Forum Discussion
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 |
| E0666-0012 |
| B0605-0052 |
| A0325-0065 |
| C0266-0065 |
| E0069-0005 |
| C0058-0085 |
| B0688-9985 |
| G2215-0085 |
Thank you
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
1 Reply
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