Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
Do the new columns come from the same data source that is used to create the original QVD?
Yes, it's from the same data source. It was never included. Now I want to include it.