How to append data to previous data using incremental load?

[saumyashah90]

I have file A.xls having data from 1st jan to 12th jan...B.xls from 8th Jan to 20th jan....i want data in qlikviewtable from 1st jan to 20th jan without

any repitition...how to do it using Incremental load..?

I tried using concatenating but it didnt work

[khadeer · Accepted solution]

U have to use insert and update and delete scenario,

write the condition for that where not existes(ur key)...

hope it helps u.

and check the attached file. It has different scenarios.