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
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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: 
jasmeenkr
Contributor
Contributor
‎2019-09-30 03:51 PM

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 (1)
Labels
6,139 Views
0 Likes
2 Replies
AdiPai
Creator II
Creator II
‎2019-09-30 04:17 PM

Check out this post 

https://community.qlik.com/t5/New-to-Qlik-Sense/Incremental-Load-on-QVD/td-p/1309066

 

6,132 Views
0 Likes
prabhu0505
Specialist
Specialist
‎2019-09-30 06:27 PM

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.

 

6,112 Views
0 Likes