topic Re: Cross Reference Tables in QlikView

..

maahivee — Fri, 17 Apr 2015 19:32:12 GMT

Re: Cross Reference Tables

maxgro — Fri, 17 Apr 2015 20:07:18 GMT

convert the history data customer number to new db customer number

the history data doesn't change, you should only convert only once the old number to new number

Re: Cross Reference Tables

maahivee — Fri, 17 Apr 2015 20:19:11 GMT

How can i do it?

In scrip or as a query? do i need to do it for all the customers ?

we have 10000 customers. and what keywords should i use?

Re: Cross Reference Tables

maxgro — Fri, 17 Apr 2015 20:27:56 GMT

in script as the old system doesn't change (I think)

for all customers

you need a conversion (mapping, decode) table from the old code to the new one or some other field (customer name?) to drive the conversion

Re: Cross Reference Tables

maahivee — Thu, 30 Apr 2015 20:13:16 GMT

This can be done in qlikview or SQL??

Also I dint understand your approach properly please help.

Re: Cross Reference Tables

petter — Thu, 09 Jul 2015 22:12:15 GMT

Create a history in QVD's or copy the data from DB1 and DB2 into the NEW DB and at the same time converting old customer numbers into their corresponding new customer numbers.