Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Compare values between 2 or more columns in the same table with values separated by comma

Hey guys,

 

I need to compare values between two columns, A and B.
The values in question come from json, and each column is an array of values. I managed to break these values by commas, but I need to identify which values do not exist between these two columns.

Is there any way to do this?

 

Example image

 

Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi Anonymous 

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

    Stéphane 

1 Reply

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi Anonymous 

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

    Stéphane