Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
A couple of comments:
1. Can you confirm that the Temp table actually contains a row with a Max_Date value?
2. You should have single quotes around your peek() params.
let vmax =peek('Max_Date',-1,'Temp');
A couple of comments:
1. Can you confirm that the Temp table actually contains a row with a Max_Date value?
2. You should have single quotes around your peek() params.
let vmax =peek('Max_Date',-1,'Temp');
HI Shree,
Please check K_Date is present in the DIM table.
You are taking max(K_DATE) as Max_Date from DIM table but i am not seeing the K_DATE in Dim table.
Thanks,
Sampath.
Hello Shree,
Peek() syntax is incorrect.
Regards,
yaseen
let vmax = PEEK('Max_Date',-1,Temp);
Please find the atatched Doc.
Hi Rob
Thanks for correcting me..
can u suggest me this is this the best one for incremental loading which is daily job or somehting else u suggest
Thanks
i have an issue from the qvd file i am getting date format as 02/01/2013
when i am comparing with the database date its showing as 01-FEB-2013 which is oracle..
so what i need to do either i convert date format in datase its saying not matching up or is ther a way in qv we can show the date format as 01-FEB-2013.. i used DD-MMM-YYYY its showing as 02-feb-2013..
any idea
I'm not an oracle expert but here is what I've used as the SQL WHERE for Oracle in the past.
'>= TIMESTAMP ' & chr(39) & timestamp($(vmax), 'YYYY-MM-DD hh:mm:ss') & chr(39);
-Rob
Hello Shree,
Please find the doc attached.
I have changed the date format in qv as you required in Oracle.
Regards,
yaseen
Hello,
Can this be done pulling data from SAP?