Discussion board where members can get started with QlikView.
I have a qlikview app which loads all the data from QVD files.
I need to add few columns and update the records and i dont have data stored in any other format(excel or csv).
How can i do that?
Basically how can i update/modify the QVD files???
you want to add a field (e.g. tx), the data is in a table where the sales number is matching at:
//now read all qvd in a folder you want to edit (my example: all sales* files)
for each file in filelist('qvd\sales*.qvd');
//show the actual file in log
//load data from the qvd
//add a new field called Tax, the values are from the csv-file from)
applymap('Map',Salesno,0) as Tax
from '$(file)' (qvd);
//store new data with same name
store Data into '$(file)' (qvd);
drop table Data;
//use next file
hope this helps
If you actually need manual data input then that's not very simple because QlikView isn't really built for data entry.
Here is one possible workaround:
1. Load the QVD
LOAD * FROM yourfilename.qvd(qvd);
2. Store the loaded table again, but as txt:
STORE yourtablename INTO yourfilename.txt(txt);
3. Edit the txt. It's a csv (or a tab delimited file... can't remember), so you should be able to use excel to do that.
4. Save your data, reload back into QlikView, store back into qvd if desired
There is also third party application which allows for direct edits of QVD files (Q-Eye, it's free) but whether it's something right for you you'll have to find out yourself.
Here is a dirty solution:
They have a free tool that opens up qvd-files and allows you to modify them. No guarantee for the quality of the product, so take a backup first.
I would still recommend the correct process of Load, Modify, Store within a QlikView script though that have been proposed above my other community members.
(Personally I just use the tool to quickly view the content of QVD-files)
For viewing QVDs, I consider QViewer a better and most robust tool. However, if you need to edit directly QVDs, then Qeye is a good choice,