Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Because you don´t need to "SELECT" from a QVD
This would be enough:
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
FROM [..\QVD\01_Extract_QVD\DM_STAT_TASK.QVD] (qvd)
where [TASK_STATUS] <> ('Cancelled') and [TASK_STATUS] <> ('Completed');
Because you don´t need to "SELECT" from a QVD
This would be enough:
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
FROM [..\QVD\01_Extract_QVD\DM_STAT_TASK.QVD] (qvd)
where [TASK_STATUS] <> ('Cancelled') and [TASK_STATUS] <> ('Completed');
you dont need select statement in order to load from qvd. I have attached app and sample data. Please check.
Thanks!