Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
timhampton
Partner - Contributor
Partner - Contributor

QVD incremental load - Adding a new column to existing incremental QVD

We use the QVD incremental load approach for generating/updating the QVDs we use for daily data refreshes for an ODAG app. The incrementals load just fine, however we want to add a new column/field to the QVD but it's not bringing in values for all rows. In this particular scenario, the column is non-nullable, so there's always a value. I assume it's only bringing in the new column's values for the new/updated rows instead of everything.

Is there a way to get the new column fully populated in the QVD without having to reload the entire file? If so, that would be great because for some of our clients their QVDs are quite sizeable (for example one client's QVDs we need to add the column to are each already over 5GB in size).

Labels (4)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can do a one time update to join the new column to the existing QVD. Something like:

ExistingData:
LOAD * From existingQvd.qvd (qvd);

Left Join (ExistingData)
SQL Select Keyfield, NewColumn
from db.table;

STORE ExistingData into ExistingData.qvd;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can do a one time update to join the new column to the existing QVD. Something like:

ExistingData:
LOAD * From existingQvd.qvd (qvd);

Left Join (ExistingData)
SQL Select Keyfield, NewColumn
from db.table;

STORE ExistingData into ExistingData.qvd;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com