topic Re: How to update the old qvds? in QlikView

How to update the old qvds?

durgabhavani — Sun, 30 Aug 2015 09:57:46 GMT

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 — Sun, 30 Aug 2015 10:15:49 GMT

See this:

maxgro — Sun, 30 Aug 2015 15:14:09 GMT

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;