Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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
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