Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any help from anyone.
Thanks,
Ajay
Check this it may help you. Incremental Load in QlikView – Part2 | Learn QlikView
Hi Ajay,
Check my app.
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
PFA,Hope this helps,
Regards,
Sundar
Thanks Venugopal,Massimo and Sundara for indetail information of incremenatal load.
Thanks,
Ajay