Incremental Load: And Field not found error

helen_pip — Fri, 04 Oct 2013 10:04:11 GMT

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

);

Re: Incremental Load: And Field not found error

Fri, 04 Oct 2013 12:38:40 GMT

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.

topic Incremental Load: And Field not found error in QlikView

Incremental Load: And Field not found error

Re: Incremental Load: And Field not found error