Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jasmeenkr
Contributor
Contributor

Append new data to existing qvd

Hi All,

I have requirement to load a whole week data to Fact QVD . How to append new data to existing QVD 

Labels (2)
2 Replies
AdiPai
Creator II
Creator II

prabhu0505
Specialist
Specialist

Assuming you are receiving weekly or daily data dump (as flatfile or table in DBMS).

In load script

Step 1: Read QVD with previous dump

Step 2: Read latest data dump from the source, make sure QVD table structure (fields names and number of fields) and this new dump table structure are same. Qlik will do automatic concatenation.