topic Add field & populate to historical data in QlikView

Add field & populate to historical data

Mon, 01 Jun 2009 20:01:05 GMT

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.

Add field & populate to historical data

Mon, 01 Jun 2009 23:01:46 GMT

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;

Add field & populate to historical data

Tue, 02 Jun 2009 14:58:57 GMT

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.