5 Replies Latest reply: Sep 8, 2014 11:44 AM by Colin Albert RSS

    Comparing two tables and creating a new with the non matching output

      Hi,

       

      I have two tables with the following fields and data:

       

       

      App Name Total
      App1
      App2
      App3
      App4

       

       

      App Name Active
      App1
      App2
      App3

       

      Wanted output:

      [Inactive apps]:

      Unused
      App4

       

      I have tried loading the first table in a temp table, then joining the second field with this table, and then doing a resident load in a final table using the following code:

       

      temp:

      load

           AppName as [App Name Active]

      Resident [(...another table)];

       

      Concatenate

      load

      Document as [App Name Total]

      resident [(...another table)];

       

      [Inactive apps]:

      NoConcatenate

      LOAD

           [App Name Total],

           [App Name Active]

      Resident temp

      Where [App Name Total] <> [App Name Active];

       

      DROP Table temp;

       

      Any ideas on why this is not giving me the correct output?

       

      Best regards,