topic Re: Re: Insert & Update in QlikView

Insert & Update

ajaykumar1 — Sat, 21 Jun 2014 13:37:48 GMT

Hi Everyone,

I have to Insert new records and update the existing data with new value.I have gone through the more Incremental load concepts & blogs but still have the confusion.Can any one share the script for the same here.Its little bit urgent.

I am attaching the sample data as well with reload dates(like Jun20,Jun21 and final out put as well).

Please let me know if in case of any clarifications.

Thanks in advance,

Ajay

Re: Insert & Update

ajaykumar1 — Sat, 21 Jun 2014 13:53:42 GMT

Any help from anyone.

Thanks,

Ajay

Re: Insert & Update

Sat, 21 Jun 2014 15:09:39 GMT

Check this it may help you. Incremental Load in QlikView – Part2 | Learn QlikView

Three Types of Qlikview Incremental Loads | resultdata

Re: Re: Insert & Update

Sat, 21 Jun 2014 17:18:37 GMT

Hi Ajay,

Check my app.

Re: Insert & Update

maxgro — Sat, 21 Jun 2014 18:07:57 GMT

I think you can solve it without an incremental load, just load the last day and choose the last (by date) record for every id

Directory;

tmp:
LOAD ID, AMOUNT, APPDATE, LOCATION
FROM [Insert&update_Sample Data.xlsx] (ooxml, embedded labels, table is [21 Jun]);

final:
NoConcatenate 
load *
Resident tmp
where Peek(ID) <> ID
order by ID, APPDATE desc;

DROP Table tmp;

if you want to do an incremental see attachment

Re: Insert & Update

sundarakumar — Sat, 21 Jun 2014 18:18:09 GMT

PFA,Hope this helps,

Regards,

Sundar

Re: Re: Insert & Update

ajaykumar1 — Mon, 23 Jun 2014 04:59:45 GMT

Thanks Venugopal,Massimo and Sundara for indetail information of incremenatal load.

Thanks,

Ajay