3 Replies Latest reply: Aug 30, 2017 3:30 AM by Reinhold Graf RSS

    how to eliminate non-matching records

    Reinhold Graf

      Hi.

       

      I have to files: Customer and CustomerGroups.

      In CustomerGroups, some(not all) customers are allocated to certain groups.

       

      After loading the data, all customers stored in 'CustomerGroups' are allocated correctly.

      But, of course, some are not, which is also correct.

       

      Showing now Customers with the CustomerGroup in a table, gives me also those customers, which don't have a CustomerGroup.

      This is not requested.

       

      How can I now eliminate those entries from the analysis-table ?

       

      Relevant Table is attached.

       

      Reinhold