5 Replies Latest reply: Nov 19, 2013 5:24 AM by Justin Morley RSS

    Script equivalent to SQL minus

    Justin Morley


      Hi all,

      Is there a QlikView script equivalent to the SQL minus command?

      Here is a definition I just pulled from the interwebs: "The SQL MINUS query returns all rows in the first SQL SELECT statement that are not returned in the second SQL SELECT statement."

       

      I have two data sets which look like this:

       

      ID

      1

      2

       

      and

       

      ID

      1

      2

      3

       

      I want a command which returns just:

       

      ID

      3

       

      I know I can write script to compare the datasets, but I was wondering if there was a native method?

      This is similar to incremental load in many respects, but I've got to do an expensive service call with each new record

       

      Thanks in advance,

       

      Justin