2 Replies Latest reply on Aug 3, 2015 3:23 AM by AlexanderGrefrath

    compare tables (complement ...)

    AlexanderGrefrath

      Title

      compare tables (complement ...)

      Post

      This is probably a stupid question and an easy task. But I do not get a grip to the following problem:

      I have two lists of numbers, lets say:

      List-1: 1,2,3,4,5,6

      List-2: 3,4,7

      I want to import those lists into a table each and than identify the entries, that both have in common (3,4) and a list of entries reduced by the "common" entries (List-1-reduced: 1,2,5,6 and List-2-reduced:7).

       

      Can anybody help me? I assume it will be a "join" mechanism, but I do not manage to design it properly.