How to input an existing .QVD, input data to "Update" the .QVD and then recreate the .QVD
With apologies, I did not title my previous post correctly regarding my question on how to update a .QVD file. I trust that the above title is clearer. But from the responses that I did get, the solution is to combine both sets of data into a new table and then override and recreate the previous .QVD using the same name. When I run the below script, I get the error:
Table not found
CONCATENATE
LOAD * RESIDENT [OldOrders]
The script is attempting to take [NewOrders] as an input .csv, [OldOrders] as the existing .QVD, create a new [AmalgamatedOrders] and then recreate/replace the original .QVD. But I am missing something.
Here is the script:
[NewOrders]:
LOAD OrderID,
OrderDesc,
OrderQty
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
[OldOrders]:
LOAD OrderID,
OrderDesc,
OrderQty
FROM
(qvd);
[AmalgamatedOrders]:
NOCONCATENATE
LOAD * RESIDENT [NewOrders];
CONCATENATE
LOAD * RESIDENT [OldOrders];
STORE AmalgamatdOrders INTO c:/QVProgramTestDevelopment/OrdersInQVDFormat.qvd]
(qvd);
I only have the QV desktop so I cannot read any revised .QVW. Is there a better way??
Qlikview concatenated tables automatically if they have the same data-structure what meant in your case that the load from OldOrders didn't create these table - it will be simply concatenated to the table NewOrders. You could solve it with a Noconcatenate-Statement:
Qlikview concatenated tables automatically if they have the same data-structure what meant in your case that the load from OldOrders didn't create these table - it will be simply concatenated to the table NewOrders. You could solve it with a Noconcatenate-Statement:
