AnsweredAssumed Answered

compare tables (complement ...)

Question asked by AlexanderGrefrath on Jul 28, 2015
Latest reply on Aug 3, 2015 by 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.

 

 

 

 

 

Outcomes