Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to append the inserted records from the DB to my QVD incrementally.
But dont want to update records which will be deleted.
The script runs daily in server..how to update this logic? as the script runs daily, the initial load gets refreshed and the deleted records too gets updated in the qvd.
Any suggestions with sample?
Thanks in advance...Steve Dark
Have you gone through reference manual? Search 'Using QVD Files for Incremental Load' in the pdf. Possibly, the second case(Case 2: Insert Only) explained there would suit your need.
Hi,
Have a look at the attached document
Regards
ASHFAQ
Hi there,
This post deals with incremental loads and will hopefully cover what you need to do:
http://www.quickintelligence.co.uk/qlikview-incremental-load/
Steve
Thanks all.
I got it..My bad. did a silly mistake while appending the updated records. I wanted to retain the old records as well.