Forum Discussion

jnixon's avatar
jnixon
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Comparing lists

Hi everyone!  I have a table that has two columns that contain lists of text items and would like to add a third column that would display whether the lists match:   The [List X]{0} differs fr...
Need Help
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    Hello

    as lists can be compared by themselves,  meaning {}={} you can use the following syntax

    =Table.AddColumn(YourTable, "ListX=ListY", each [List X] = [List Y])

     

    have fun

    Jimmy

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

Hello

as lists can be compared by themselves,  meaning {}={} you can use the following syntax

=Table.AddColumn(YourTable, "ListX=ListY", each [List X] = [List Y])

 

have fun

Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Well that was easy. I did not even think to do that. Thanks for the tip!

  • jnixon's avatar
    jnixon
    Icon for Advocate II rankAdvocate II
    6 years ago

    Wow, worked like a charm!  i was definitely overthinking things.  I guess I'll put off fully understanding List.Accumulate to another day - no worries!

    Thanks.