Forum Discussion

Frequent Visitor

2 years ago

Solved

How to compare 2 cells text with delimiter and demonstrate difference?

Please, I need your tips.

I have two grouped columns in one table.

How can I compare it and demonstrate the difference? Power Query solution.

I've found VBA but in power query can not 😞

Colors Set A Colors Set B Result A to B Result B to A

A	B	Result A to B	Result B to A
red;blue;green	yellow;purple;red	blue;green	yellow;purple
white;green;red	yellow;red	white;green	yellow

Text.Combine(
  List.Difference(
    Text.Split([A],";"),
    Text.Split([B],";")),
  ";#(lf)"))

Stéphane

4 Replies

slorin
Super User
2 years ago
Hi, MykytYla

Result A to B

Text.Combine(
List.Difference(
Text.Split([A],";"),
Text.Split([B],";")),
";")

Result B to A

Text.Combine(
List.Difference(
Text.Split([B],";"),
Text.Split([A],";")),
";")

Stéphane
- MykytYla
  Frequent Visitor
  2 years ago
  slorin Thank you so much!
  It looks such easy but I couldn't handle it.
  
  PS. Could you advise me any good studying for formulas power query and DAX?
MykytYla
Frequent Visitor
2 years ago
can I get cells with text in new line?
A B Result A to B Result B to A
red;blue;green yellow;purple;red
blue;
green
yellow;
purple
white;green;red yellow;red;purple
white;
green
yellow;
purple
- slorin
  Super User
  2 years ago
  Text.Combine(
  List.Difference(
  Text.Split([A],";"),
  Text.Split([B],";")),
  ";#(lf)"))
  
  Stéphane