Trying to edit qvd file

[new2qlik]

Hi,

I'm new to qliksense and been messing with it. Currently, trying to add columns to an existing qvd file.

I have the qvd open in qlikview and see the script.  My data are loaded automatically via mysql and odbc.

However, on this script, I don't see where it's loading the data via those methods.

I see LOAD, invoicenumber, subtotal, freight, etc

FROM C:\Users\desktop\total.qvd

I'm trying to figure how this is setup. I'm able to select odbc, select the table and columns that I want, but that's as far as I can go.
Is there a step by step somewhere? I can't find it.

[jwjackso]

To create the QVD, you use the Store command.

DeptTable:

load * inline [

Dept

1

2

3

];

Store DeptTable into DeptTable.qvd (qvd);

This overwrites the QVD.

[new2qlik]

I guess I'm confuse as to how it's setup to pull data automatically from odbc.
However, this script doesn't show any of that.

[Vegar]

You should try to find the application that is creating the total.qvd file.

It will be the file containing a script line similar to this:
Store total into total.qvd (qvd)

If you load the qvd into a text editor you should also be able to find the source qvw file location and file name within the xml part of the qvd file

[new2qlik]

That was it. Thanks!

Is it normal for the bottom of that file in text editor to look gibberish while the top is actual data and source location?

[Vegar]

It is completely normal.

The top part contains the xml header and the bottom contains the qvd data part which is not stored as plain text.

[new2qlik]

How do I just add a column to existing qvd?

I see the list of Load items

I select odbc, select items from, etc.

When I go to store, I can't store because I have to name it table.

It'll be Store TABLE into E:\Total.qvd

[jwjackso]

Do the new columns come from the same data source that is used to create the original QVD?

[new2qlik]

Yes, it's from the same data source. It was never included. Now I want to include it.

[jwjackso]

Will your query be loading all the original data or only new data that needs to be appended to the QVD?