Forum Discussion
Duplicate values in selection filter
Dear Along with greeting, I have a problem with the selection filter where certain values appear duplicates to me. I have checked the source, and all the data is well written (there ...
I found the error, the data in the source, were separated as ", "and not ",", for that same reason, there were duplicate countries because there were rows that only had 1 country (example: Panama) and another that had several (Chile, Panama, Honduras).
Best regards!
Hi Matias1986 ,
If I understand correctly, there are duplicated values in the field [Pais], and it seems that it got from a separated column. Could you please provide some raw data in the source field? Thank you.
If you have the data in the following table, you can follow the steps below to handle with it in Power Query Editor. Please find the details in the attachment.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WStRJ0knWSVGK1YlWStVRSNNRUEjXUcjQyQSLZOlk6yjk6CjkKsXGAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4"}),
#"Trimmed Text" = Table.TransformColumns(#"Split Column by Delimiter",{{"Column1.1", Text.Trim, type text}, {"Column1.2", Text.Trim, type text}, {"Column1.3", Text.Trim, type text}, {"Column1.4", Text.Trim, type text}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Trimmed Text",{{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}, {"Column1.4", type text}})
in
#"Changed Type1"
Best Regards