4 Replies Latest reply: Nov 5, 2014 11:46 PM by Vasu Jambunathan RSS

    How to do IN statement in LOAD Script

      Hi

       

       

      I have the need to perform a task similar to the SQL IN statement.

       

      I am performing two load processes into temporary tables:

       

      Table1:

      LOAD

           column1,

           column2,

           column3

      FROM

           [..\..\DATA\DATASET1.qvd] (qvd)

      WHERE

           arguements here;

       

      Table2:

      LOAD

           column4,

           column5,

           column6

      FROM

           [..\..\DATA\DATASET1.qvd] (qvd)

      WHERE

           different arguements here;

       

      What I would like to do after is something like this:

       

      Table3:

      LOAD

           Column7,

           Column8,

           Column9

      FROM

           [..\..\DATA\DATASET1.qvd] (qvd)

      WHERE

           Column7 NOT IN RESIDENT (Table2) Column4;

       

      Any help is greatly appreciated.

       

      Graham