Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
kushalthakral
Creator III
Creator III

Incremental load without date in Database

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

I think you need a primary key

see here

Re: Incremental load for Updation

case 3

View solution in original post

6 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

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

Three Types of Qlikview Incremental Loads | resultdata

http://www.quickintelligence.co.uk/qlikview-incremental-load/

alexandros17
Partner - Champion III
Partner - Champion III

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
MVP
MVP

I think you need a primary key

see here

Re: Incremental load for Updation

case 3

MK_QSL
MVP
MVP

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

kushalthakral
Creator III
Creator III
Author

Hi All

Thanks

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

Thanks

MK_QSL
MVP
MVP

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