Incremental Loading daily.

[shree909]

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..

[rwunderlich · Accepted solution]

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');

[#3]

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.

[#4]

Hello Shree,

Peek() syntax is incorrect.

Regards,

yaseen

let vmax = PEEK('Max_Date',-1,Temp);

[#5]

Please find the atatched Doc.

[shree909]

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

[shree909]

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

[rwunderlich]

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

[#9]

Hello Shree,

Please find the doc attached.

I have changed the date format in qv as you required in Oracle.

Regards,

yaseen

[#10]

Hello,

Can this be done pulling data from SAP?