Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

saumyashah90
Valued Contributor

How to append data to previous data using incremental load?

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

1 Solution

Accepted Solutions
khadeer_sparks
Valued Contributor

Re: How to append data to previous data using incremental load?

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.

1 Reply
khadeer_sparks
Valued Contributor

Re: How to append data to previous data using incremental load?

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.

Community Browser