5 Replies Latest reply on Apr 26, 2012 4:48 AM by toddsherwood

    How does one find rows from Table A that are not in Table B?

      How in Tableau 7.0 does one find rows from Table A that are not in Table B where Tables A and B are joined on a common Integer Key Field 1?  To make life a little more complicated, Table B is also indexed by a 3 character Field 2. Field 2 is present in Table A, but is imbedded in a string that may contain multiple Field 2 instances (e.g. "ABC DEF GHI" represents 3 instances of Field 2).  It is also desired to find rows in Table A that have Field1/Field 2 instances not present in Table B.

       

      Table A turns out to be an external customer problem report database.  Key Field 1 is the problem number.  Non-Key Field 2 is a space-separated list of customer site(s) where the problem was hit.  Table B is an internal company database.  Key Field 1 is the problem number, and Key Field 2 is used to track data on a per customer site basis.

       

      The customer finds new problems and finds existing problems a new sites.

       

      The task is to identify new problems and new instances of existing problems in the customer database so the issues can be added to the company database.

       

      All insights will be very much appreciated!