Add field & populate to historical data

[#1]

Hi,

I have a QVD table of around 40 Million records ( our sales data going back a number of years), it has now been decided that the users would like a additional field on each one of these records. I have got a additional QVD file that contains invoice number for the link to the existing data and the vale of the new field for each invoice number. I have tried numerous ways to add this to our existing QVD but failed, Is not possible to recreate the full file because some of the table is transient. Any help would be appreciated.

[#2]

Have you tried this --

[UPDATED_DATA]:

LOAD

*

FROM OriginalQVD.qvd (qvd);

LEFT JOIN

LOAD

invoice_no, new_field

FROM

<new file> // replace as required for .csv / .xls / .txt

STORE [UPDATED_DATA] INTO OriginalQVD.qvd;

[#3 · Accepted solution]

I did try this but could not get it to work, I ended up with to many records.

In the end I added the field to the original with a default value of 0 and then did a left join. It seemed to work then.

Thanks for your reply.