Forum Discussion
Resolver IICompare two text columns and write the difference in the third column in PowerQuery
Super Useryou can try this to create a new column in PQ
= Table.AddColumn(#"Changed Type", "Custom", each
[a=Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)(Text.Remove([Employee States]," ")),
b=Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)(Text.Remove([Manager States]," ")),
c=List.Difference(a,b),
d=Text.Combine(c,",")
][d])
LP280388ryan_mayu , Thank you. It did work with the sample data I provided. Thanks for the same.
In my original data i have company names with space included like the below. May I know how can i modify this query to suit this.
Employee States Am ciat, Brian be, Ceat kod, Doug fen - ryan_mayu
you can try this
= Table.AddColumn(Source, "Custom", each
[a=Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)(Text.Trim([Employee States]," ")),
b=Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)(Text.Trim([Manager States]," ")),
c=List.Difference(a,b),
d=Text.Combine(c,",")
][d])