8 Replies Latest reply on Jun 11, 2013 12:59 AM by Alejandro Barreras

    Filtering a datasource with existing records in another datasource

    Alejandro Barreras

      Hello, I'm trying to filter existing records but seems that doesn't work fine for me... let me explain:

       

      Imagine that you have an Excel file with a list of records, ID and Description

      ID - Desc

      1  - a1

      2  - a2

      3  - a3

      ...

      30 - a30

       

      On the other hand, you have another Excel file with the same structure and with the following records:

      1 - a1

      3 - a3

      5 - a5

      ...

      29 - a29

       

      If I link the two files with the ID, is simple to see which ones are and which ones are not in the file, because I obtain the following result:

       

      1 - a1

      2 - null

      3 - a3

      ...

      29 - null

      30 - a30

       

      It is very simple to remove the null ones, having only the records which are in the two files.

       

      What I want to do is to remove the ones which exist on the second file (IDs 1, 3, 5... 29) and keep only the remaining ones which their full description. Sumarizing: Remove the ones which appear in the two files and keep the standalone ones which are on the 1st file and not in the second.

       

      Do I need to create a calculated field, operate with a table? I'm lost...

       

      Thanks!