Incremental load issue

[khajafareed]

Hello All,

I have below data, for one task i have two records. While doing incremental load it is fetching only one record. How to fetch two or all the records if we have more than one or two.

SLA definition	Target	Task	Stage	Breach time	Has breached	Updated
Response	Response	INC0055052	Completed	2020-10-06 10:00:00	FALSE	2020-10-06 05:58:32
Resolution	Resolution	INC0055052	Completed	2020-10-13 17:00:00	FALSE	2020-10-12 07:00:02

[MayilVahanan]

HI @khajafareed 

If incremental load is based on breach time, it will fetch all / both the records.

[khajafareed]

Thanks for response, i am doing incremental load based on updated field.But not getting both records.

[martinpohl]

How does your incremental load looks like?

Understand QlikView:

When press on reload or start a reload tasks, all datas in your app are deleted. 

So if you want to load old datas and new datas into one app you have to create an app that loads your datas from your source by day and store them into a qvd-file on your QlikView server (with day-name in filename). Then load all your datas (SLA*.qvd) into your app.

Regards

[martinpohl · Accepted solution]

in your script there is a statement

where not Exists(Number)

so each Number is only loaded one time, the first dataset the script will find.

mark this line to get all datas.

Regards