Discussion Board for collaboration on QlikView Scripting.
I have one QVD and i forgot to add one column in that and table from which i have created the QVD its large.
any way to add a new column to that existing QVD.and i want to add that new column from database.
Without having to reload it ?
Not sure I can see a way around it - add the column to the script, save and then reload on the server would be my best guess.
Use Partial Reload concept for this kind of situation.
You can load only missed columns with table key field to the separate table and join with existing table by key field.
Firstly load the qvd which have your additional 5 columns means CusterMaster;
load Customer_master qvd;
make sure that in between two qvd's there's one primary key if there is field name change but data is same then use as function or make it same field name
Try like this
FROM QVDFile.qvd (qvd);
STORE Data INTO QVDFile.qvd;
Hope this helps you.
Try like this;
ADD Load A, //which is key field
D //missing field(s)
Then save the application and go to front end then file--partial reload.
ADD :The ADD key word is used to reload the only new table(s).Called as partial reload.
It works like mapping will happen between the already loaded table and the newly field added table.
Your QVD is optimised.. when loading from a qvd, its not the same as loading from the database.
Load the existing fields from your qvd and just load the additional one from database into a new qvd. (Give it a new name or rename the old one first.
LOAD Key, Rest, Of, QVD FROM C:/YourQVD.qvd (qvd);
Join LOAD Key, OtherField;SQL SELECT Key, OtherFieldFROM DB.dbo.Table;STORE YourQVD into C:/MyNewQVD.qvd (qvd);
create an inline table and concatenate, you need to have same field structure for this to work
Load * inline
store Main into Main.qvd(qvd);