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.

[new2qlik]

---

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

---

It will pull original and new data.

So I was able to do it on the web base data load editor. That was able to be save.

If I get on qlik server and open that qvd on qlikview, that new column is not in there and there's no data for that column.

[jwjackso]

If you are pulling all the data and just adding another field, I would execute the new query and store it as a new QVD (unless you need to keep the name).

PUT_NAME_FOR_NEW_QUERY:

select your query goes here;

Store PUT_NAME_FOR_NEW_QUERY into NAME_OF_QVD.qvd (qvd);