topic Re: Can anyone please help me in solving this query in QlikView

Can anyone please help me in solving this query

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need to do incremental load. But I do not have data column and primary key. Also, I am not able to a unique column out of the combination of different columns. Can anyone please help me in this regard.

Re: Can anyone please help me in solving this query

saimahasan — Wed, 07 Sep 2016 08:00:03 GMT

Incremental always needs either a date field or a primary key. Without these i think it wont be possible to identify new records in the database.

Re: Can anyone please help me in solving this query

Anonymous — Wed, 07 Sep 2016 08:06:27 GMT

Hi,

Please see: https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

This could be helpful

Re: Can anyone please help me in solving this query

bindu_apte — Wed, 07 Sep 2016 08:32:14 GMT

hi,

Hope this thread will help you.

https://www.resultdata.com/three-types-of-qlikview-incremental-loads/

Re: Can anyone please help me in solving this query

rajuamet — Wed, 07 Sep 2016 08:38:04 GMT

Hi Agrim,

We can generate or set flag to incorporate incremental load in your scenario. Can you provide us any sample data.

And on what basis your incremental load should work ? I mean like hourly basis, daily basis, weekly basis or for every reload ?

Re: Can anyone please help me in solving this query

Anonymous — Wed, 07 Sep 2016 08:50:17 GMT

may be helpful for you?

Incremental Load without Date field

Re: Can anyone please help me in solving this query

Anonymous — Wed, 07 Sep 2016 08:51:32 GMT

It would be on daily basis. I am sorry as I cannot provide a sample data since it is client specific. Thanks in advance

Re: Can anyone please help me in solving this query

Anonymous — Wed, 07 Sep 2016 09:05:38 GMT

Can you please elaborate this FLAG concept through an example. Thanks