Insert & Update

[ajaykumar1]

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

[ajaykumar1]

Any help from anyone.

Thanks,

Ajay

[#3]

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

Three Types of Qlikview Incremental Loads | resultdata

[#4]

Hi Ajay,

Check my app.

[maxgro]

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

[sundarakumar · Accepted solution]

PFA,Hope this helps,

Regards,

Sundar

[ajaykumar1]

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

Thanks,

Ajay