Forum Discussion
Find text string in column and use unique values to lookup value in a corresponding column
I don't know exactly how to describe what I'm trying to do, so hopefully the below pictures will help. I would like to create a list of all the unique values (which are separated by commas) in colum...
NewStep= #table({"Color","People"},Record.ToList(List.Accumulate(Table.ToRows(PreviousStepName),[],(x,y)=>Record.TransformFields(x,List.Transform(Text.Split(y{1},","),(x)=>{x,each {_{0}? ??x,Text.Combine({_{1}?,y{0}},",")}}),2))))
I figured out a work around. Prior to wdx223_Daniel's new step, I added a step by using the transform function to replace each instance of ", " (comma and a space) with "," (just a comma).
Now, the final step displays as desired.
I figured out a work around. Prior to wdx223_Daniel's new step, I added a step by using the transform function to replace each instance of ", " (comma and a space) with "," (just a comma).
Now, the final step displays as desired.