topic Re: Incremental load without date in Database in QlikView

Incremental load without date in Database

kushalthakral — Fri, 18 Apr 2014 09:59:48 GMT

Dear All

Ho to do an Incremental load if we dont have Date in database

and also structure of incremental load with example also help

Thanks

Kushal Thakral

bbi_mba_76 — Fri, 18 Apr 2014 10:19:29 GMT

Hi,

you have to find a key field (or combination of fields) and then use the not exists function

alexandros17 — Fri, 18 Apr 2014 10:20:35 GMT

Only an idea:

Add a loading date on your own in order to introduce a date.

In this way you can compare (by primary key) all records with date

maxgro — Fri, 18 Apr 2014 10:23:39 GMT

I think you need a primary key

see here

case 3

MK_QSL — Fri, 18 Apr 2014 10:31:01 GMT

If you dont have date, you need at least something to define as primary key... say Invoice Number

kushalthakral — Fri, 18 Apr 2014 10:34:16 GMT

Hi All

Thanks

It would be nice if you can give me example for the same.

Thanks

MK_QSL — Fri, 18 Apr 2014 10:35:21 GMT

You can search on YouTube... There are few videos available on Incremental Load...