Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

QVD files

Hi all,

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???

Thanks

13 Replies
Highlighted
Partner
Partner

example:

you want to add a field (e.g. tx), the data is in a table where the sales number is matching at:

Map:

mapping load

salesno,

tax

from tax.csv;

//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

trace $(file);

//load data from the qvd

Data:

load *,

//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

drop table Data;

//use next file

next

hope this helps

Highlighted
Partner
Partner

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

     yourtablename:

     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.

Highlighted
Creator
Creator

Here is a dirty solution:

http://www.etl-tools.com/products/q-eye-overview.html

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)

Kind regards

Niklas

Highlighted
Partner
Partner

Hi,

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,

regards