Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Incremental Load: And Field not found error

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

);

1 Reply
Not applicable

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.