Forum Discussion
remove distinct values from row within a column
I am trying to remove repeated values from a column
that has comma seperated values (Ex, 1,3,4,6,7,9,9,9,9) should return (1,3,4,5,6,9)
I found a match for my issue on stack overflow, which works in the example format, but when I try to apply to my query, I don't understand how to reference a specific column from my source. Would anyone be able to demonstrate to me how to fix this syntax? Thank you.
The example:
let
Source = "[email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]",
#"Distinct Values" = Text.Combine(List.Distinct(Text.Split(Source, ", ")),", ")
in
#"Distinct Values"
The example above works
My source contains multiple columns, so I tried to reference the column from source like this -
= Text.Combine(List.Distinct(Text.Split(#"PREVIOUS STEP"{"MY COLUMN NAME"}, ",")),",")
let
Source = <A BUNCH OF COLUMNS HERE>,
#"Remove Duplicates" = Text.Combine(List.Distinct(Text.Split(Source{"MY COLUMN NAME"}, ",")),",")
in
#"Remove Duplicates"
jbbcormed Try adding a custom column like this:
=Text.Combine(List.Distinct(Text.Split([YOUR COLUMN NAME], ", ")),", ")
You can then remove the original column.
2 Replies
jbbcormed Try adding a custom column like this:
=Text.Combine(List.Distinct(Text.Split([YOUR COLUMN NAME], ", ")),", ")
You can then remove the original column.
Oh my gosh, I don't know why that threw me for a loop, worked like a champ, this is like when I realize I should be doing a calculated column instead of a measure in DAX. "When it no worky, consider you are doing it in the wrong place" haha
Edit: And THANK YOU!
