How to update the old qvds?

[durgabhavani]

Hi All,

I am using one qvd creator application to create qvds.

I have qvds for last 6 months. It has one customer table having customer ids from various countries.

Now i need to update the customer ids of singapore country using the mapping file.

Is it possible to update the old qvds?

Thanks,

Durga

[ecolomer]

See this:

Insert update and delete records into QVD

Binary Load to Create QVD's

[maxgro · Accepted solution]

If I understand you want to change the id of singapore customers in 6 qvd.

Below the pseudocode.

- load the mapping file (singapore customer ids)

MapCustomer:

mapping load

CurrentCustomerId, NewCustomer Id

from somefile;

- loop on your 6 qvd files (read the qvd, change the id from current to new, store the qvd)

for each file in filelist(....)

     SomeTable:

     load

          field1, field2, .......,

          ApplyMap('MapCustomer', CustomerId) as CustomerId

     from

          .............;          // use the variable file

     store ..............;

     drop table ............;

next;