Hi guys,
i am looking to do incremetnal loading daily.
i want to do it on date field
Dim:
LOAD
UNIQUE_ID,
DATE,
[System Name],
VALUE,
Area,
Vendor
FROM
..\abc\QVDs\Dim.qvd(qvd);
i want to do it on date..
i have gone through the community and found it something like this but its not working.. can u correct me where i am going wrong
=========================Dim====================
Dim:
LOAD
UNIQUE_ID,
DATE,
[System Name],
VALUE,
Area,
Vendor
FROM
..\abc\QVDs\Dim.qvd(qvd); // this is the qvd which was loaded from this i am calulating the max date
Temp:
load max(K_DATE) as Max_Date
resident Dim;
drop table Dim;
let vmax =peek(Max_Date,-1,Temp); /// this vmax is not loading into the qlikview i dont know why
LOAD
UNIQUE_ID,
DATE,
[System Name],
VALUE,
Area,
Vendor
FROM (date base table); //// loading from date base which is on daily basis
where DATE >$(vmax )
concatenate
Dim:
LOAD
UNIQUE_ID,
DATE,
[System Name],
VALUE,
Area,
Vendor
FROM
..\abc\QVDs\Dim.qvd(qvd); /// previously loaded qvd file concatenating with the new records on the date field..
and then storing and droping the table... but the problem is when i am uing the $(Vmax) variable is not loading into qlikview.
i am not sure this is the correct way of doing incremental loading or somehting else has to be done..
