Updating historical QVD with Mapping file

[#1]

Hi All,

I have a historical qvds from jan 2014, some of our customer numbers need to update in it, now i have a mapping file with old and new customers,

how can i map my table with mapping file?

TABLE
CUSTOMER_NUM
A1

A2

A3

A4

A5

A6

(MAPPING FILE)

CUSTOMER_NUM                                                 Updated Customer no

A3                                                                         A3##### (update A3 with this customer number )

A4                                                                         A4##### (update A4 with this customer number)

I am using the field CUSTOMER_NUM in my dashboard. so i want to get the updated customer numbers in that field.

thanks,

qlikman

[maniram23]

HI,

I thought this is help full for you. you can use "add only" function in before load the statement.

[marcus_sommer]

You will need something like this:

MapCustomer:

MappingLoad Old_Customer_Num, New_Customer_Num From xyz;

QVD:

Load

     applymap('MapCustomer', Old_Customer_Num, Old_Customer_Num) as Customer_Num,

     Field1,

     Field2,

     .....

From QVD;

store QVD into QVD;

- Marcus