5 Replies Latest reply: Aug 26, 2017 12:34 AM by John Gouws RSS

    where not exists and only get one line

    Jessica Tung

      Hi I have incremental reload with where not exists syntax.

      But I am getting only one record for the history.

      I have been doing WHERE NOT EXISTS for many times, this is the first time I've seen this.

       

      //today

      LOAD Account,

                Blalance,

                 PRCS_DTE

      FROM

      [..\03_QVD\Table_Incr.qvd]

      (qvd);

       

      //History

      LOAD Account,

                Blalance,

                 PRCS_DTE

      FROM

      [..\03_QVD\Table.qvd]

      (qvd)

      WHERE NOT EXISTS (PRCS_DTE)

      ;

      where_exists.png