Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III
‎2017-11-15 05:34 AM

Incremental not working

Hi,

I load data yesterday fron database and stored it in qvd.After check all the policynumbers for it till yesterday.

After that  apply incremental load on it by using

Trunc(sysdate)-1

CONCATENATE

YESTERDAY QVD

But after incremental load count is showing wrong ? There is difference between previous qvd count(OLD DATA IN QVD) and after increment count(SAME OLD DATA IN QVD) ?

705 Views
0 Likes
2 Replies
mdmukramali
Specialist III
Specialist III
‎2017-11-15 05:39 AM

Hi,

Can you share the script here.

661 Views
0 Likes
agigliotti
MVP
MVP
‎2017-11-15 05:40 AM

Which criteria did you use to apply incremental LOAD ?

What's your table primary key ?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
661 Views
0 Likes