Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a new column added to my source database, and that should be pulled out to qlikview and append to existing qvd. what is the best way to do this ?
I know the method, run full extract and create qvd starting onwards, but the data size is in very big that takes hours to complete this. As now I am loading data incremental manner to qlikview. Pls. suggest.
Br, Balanandam
Is that column also having values corresponding to previous data?
Yes you have to run full extractor. There is no alternate way.
Regards
If the new column is based only on other columns already in the QVD, then it will not be necessary to run the full reload. Create a simple model that loads the qvd with the calculated column and store the qvd
Data:
LOAD *,
<new derived column calculation> as NewColumn
FROM $(vqvdPath)\YourData.qvd (qvd);
STORE Data into $(vqvdPath)\YourData.qvd (qvd);
No, this column has created recently and start logging data.
Br, Balanandam
How are the rows in the new column related to the existing rows?
You can modify existing QVD by adding new Column and set its default value either blank or NULL.
LOAD *,
<new column > as NewColumnName
FROM $(vQVDPath)\Data.qvd (qvd);
STORE Data into $(vQVDPath)\Data.qvd (qvd);
DROP TABLE Data
what i understood is you have a QVD,and new column was inserted in DB,
now you want to extract this column from DB and append it to existing QVD.
How abt this way!!!!!!!!!
QVD: //Loading existing QVD
LOAD *
FROM $(vqvdPath)\YourData.qvd (qvd);
Join //new column added to qvd w.r.t to commonfield(Key)
NewField:
Load <Commonfield>,
<Newfield>
From DB;
STORE QVD into $(vqvdPath)\YourData.qvd (qvd);
You don't need to used Join.
If you want to bring New columns data for Historical data also then better perform Full data load.
use partial Reload it is used to load some tables in data model instead of loading all tables.