Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am in the process of trying to write an incremental Load statement, but have 2 problems so far
The Errors
1) I get an error message stating:
Field not found - <>>
SECOND_LOADS:
2) The rest of the script LOADS o.k, but it adds the totals together, but as I am new to Qlikview I do not know that if I sort out problem 1, problem 2 will cease to exist
The 2 QVDS
INITIAL_LOAD.qvd is loading in data between 01/05/2012 and 30/09/2012 (Results = 87427 rows)
SECOND_LOAD.qvd is loading in data from between 01/10/2012 and 30/09/2013 (Results = 218386 rows)
Both QVD's contain the same field names
The Aim
The aim is to concatenate SEOND_LOAD onto the end of INITIAL LOAD so I end up with 305813 rows (87427+218386)
Can anyone kindly help?
The Syntax
Temp:
LOAD
ENCOUNTER_NO ,
WARD_CODE,
EFFECTIVE_DATE,
EPISODE_NO,
WARD_CLASS,
DATE_UPDATED,
USER_UPDATED,
FUNCTION_CODE,
NUM_DAYS,
EFFECTIVE_HOUR,
WARDSTAY_ID,
WARD_STAY_START_DATE,
WARD_STAY_END_DATE
FROM
Q:\DEVELOPMENT\HP\QVD\INITIAL_lOAD.qvd
(qvd); //This qvd has data in it from 01/05/2012 to 30/09/2012
Res:
LOAD Max(Date(WARD_STAY_START_DATE,'DD/MM/YYYY')) AS MaxDate
RESIDENT Temp;
let vMax=
peek('MaxDate',-1,'Temp');
Directory;
SECOND_LOADS:
LOAD
ENCOUNTER_NO ,
WARD_CODE ,
EFFECTIVE_DATE ,
EPISODE_NO ,
WARD_CLASS ,
DATE_UPDATED ,
USER_UPDATED ,
FUNCTION_CODE ,
NUM_DAYS ,
EFFECTIVE_HOUR ,
WARDSTAY_ID ,
WARD_STAY_START_DATE ,
WARD_STAY_END_DATE
FROM
Q:\DEVELOPMENT\HP\QVD\SECOND_lOAD.qvd(
qvd)
//This qvd has data in it from 01/10/2012 to 30/09/2013
WHERE DATE(WARD_STAY_START_DATE,'DD/MM/YYYY') > $(vMax);
Concatenate
LOAD* FROM
Q:\DEVELOPMENT\HP\QVD\INITIAL_lOAD.qvd
(qvd
);
Hello,
The last command could be unnecessary because qlikview will automatically concatenate 2 tables which have same columns unless if you don't use Noconcatenate command.
So maybe you should try without the last Concatenation part.
Try without this:
Concatenate
LOAD* FROM
Q:\DEVELOPMENT\HP\QVD\INITIAL_lOAD.qvd
(qvd);
Best.