Issue with incremental load

Wed, 09 May 2012 22:47:22 GMT

Hi,

I am trying to load data greater than a certain date as incremental to the previous load.

The step I followed is

1. Stored the previous load as a qvd

2. Load the qvd

3. Get max date

4. Load the new data where date is greater than max date from previous loaded qvd file.

I am getting an error field <vMax> not found. Below is the script. Does anyone know what could be happening and how to resolve this issue.

Thanks,

Deepak

Temp:
LOAD * from Sales_Fact.qvd (qvd);
Res:
LOAD Max(%_Day_Date_ID) as MaxDate
RESIDENT Temp;
let vMax=peek('MaxDate',-1,'Temp');

Directory;
Sales_Fact:
LOAD TEXT(Terr_id) as %_Terr_ID,
     TEXT(Brand) as %_Brand_ID,
     DATE(w_date) as %_Day_Date_ID,
     NUM(sales) as FCT_sales

FROM
[sales_inputs - we4-20-12.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE
DATE(w_date) > vMax;

Concatenate

LOAD * from Sales_Fact.qvd (qvd);

topic Issue with incremental load in QlikView

Issue with incremental load