Get distinct words from a field

[McMonty]

Hi,

Is it possible to create a new column with unique values for each original row?

Equipment_original	Equipment_New
Hosted telecoms, Hosted telecoms, Hosted telecoms	Hosted telecoms
Rigid Dump Trucks, Excavators, Rigid Dump Trucks	Rigid Dump Trucks, Excavators
Mobile Phones, Mobile Phones	Mobile Phones

Thanks

[Anonymous]

Hi @Ritaf1983 ,

Thanks for your sharing.

@McMonty ,I have created a simple sample, please refer to my pbix file to see if it helps you.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8sgvLklNUShJzUlNzs8t1lEgJKCkg65HKVYnWikoMz0zRcGlNLdAIaSoNDkbqNG1IjmxLLEkvwjIxpAGGoNXC9hQ3/ykzJxUhYCM/LxUoCwKF2gAKj82FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Equipment_original = _t, Equipment_New = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Equipment_original", type text}, {"Equipment_New", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Equipment_original", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Equipment_original.1", "Equipment_original.2", "Equipment_original.3"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Equipment_original.1", type text}, {"Equipment_original.2", type text}, {"Equipment_original.3", type text}}),
    #"Removed Duplicates" = Table.Distinct(#"Changed Type1", {"Equipment_original.1", "Equipment_original.2", "Equipment_original.3"}),
    #"Removed Columns" = Table.RemoveColumns(#"Removed Duplicates",{"Equipment_original.2", "Equipment_original.3"})
in
    #"Removed Columns"

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @McMonty 
Please refer to the linked video :

https://www.youtube.com/watch?v=VjerGJGMs5M

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly