topic Re: Incremental load issue in QlikView

Incremental load issue

khajafareed — Tue, 10 Nov 2020 17:48:06 GMT

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

Re: Incremental load issue

MayilVahanan — Tue, 10 Nov 2020 10:08:46 GMT

HI @khajafareed

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

Re: Incremental load issue

khajafareed — Tue, 10 Nov 2020 10:44:07 GMT

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

Re: Incremental load issue

martinpohl — Tue, 10 Nov 2020 10:51:27 GMT

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

Re: Incremental load issue

martinpohl — Tue, 10 Nov 2020 11:44:26 GMT

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