2 Replies Latest reply: Nov 20, 2011 10:46 AM by charusama RSS

    Tell me how to compare two tables

      Hi,

       

      I have two tables with the same field names, such as Table-A  and Table-B. Table-A includes some of the same records of Table-B. When I have to extract the records from Table-A which do not exist in Table-B, what shall I do?

       

        • Tell me how to compare two tables

          Hi Charusama

           

          Are you doing this in the script? Try using "where not exists(field1, field2)"  after a load.

           

          If you are doing it in the document itself, eg a in a table chart, then I would use a test on a value in a field in table b that you always know will be populated  - for example an id field (although you may need to create it).

           

          An example would be =if(isnull(B_ID),.....). You could also do this in script if you wanted.

           

          Is this useful?

           

          Erica