AnsweredAssumed Answered

compare tables (complement ...)

Question asked by AlexanderGrefrath on Jul 28, 2015
Latest reply on Aug 3, 2015 by AlexanderGrefrath


compare tables (complement ...)


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.