Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
maahivee
Contributor III
Contributor III

..

..

5 Replies
maxgro
MVP
MVP

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

maahivee
Contributor III
Contributor III
Author

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?

maxgro
MVP
MVP

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

maahivee
Contributor III
Contributor III
Author

This can be done in qlikview or SQL??

Also I dint understand your approach properly please help.

petter
Partner - Champion III
Partner - Champion III

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.