Hi,
I believe you can achieve this by using RDM and a cleanser. In the RDM lookup, map the code as the source and the value as Canonical value, and in the cleanser (existing or custom depending on your requirement), have the code mapped to both code and value attributes which will then invoke the RDM for translation and you will get the value from the code.
I hope this helps. Try it out and please post your comments here.
Thanks,
Harsha Karumuri
------------------------------
Harsha Karumuri
Dodge Data and Analytics
Hamilton TownshiP NJ
------------------------------