Forum Discussion
Compare two text columns and write the difference in the third column in PowerQuery
you 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])
you 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])
ryan_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
