3 Replies Latest reply: Sep 10, 2015 12:43 PM by Cassandra Baqir RSS

    Where Clause in QVD Load

    Cassandra Baqir

      I saw something similar to this but not quite the same so I am asking for some help... I need to exclude two values in a field from my QVD load... but this is not working

       

       

       

      LOAD "TASK_ID",
         "TASK_NAME",
         "TASK_STATUS",
      "TASK_SEQ",
      date([TASK_SCHED_START_DATE], 'MM/DD/YYYY') as TRX_DATE,
      "TASK_SCHED_END_DATE" as TASK_START_DATE,
      "TASK_SCHED_END_DATE" as TASK_END_DATE,
      "TASK_SCHED_LAST_UPDATE_DATE" as TASK_LAST_UPDATED_DATE;
      SQL SELECT *
      FROM [..\QVD\01_Extract_QVD\DM_STAT_TASK.QVD]
        (qvd)
      where [TASK_STATUS] <> ('Cancelled') and [TASK_STATUS] <> ('Completed');

      What am I doing wrong in my Where clause? It works when it's not loading from the QVD.

       

      Thanks,

      Cassandra