Decode based off a table within Database

Hi,
 
In our database we have a codes and descriptions table which is a conversion of all the databases technical terms and abbreviations to simple English, like for example M is to Male. Is there a way to use this to clean up the abbreviated codes of columns such as gender? I understand that the decode function can run off an uploaded document as well as having the option of manually inputting the new names but is there any alternative way of decoding in bulk? 
 
Thanks,
Harrison

Find more posts tagged with

Comments

micajblock

You have 2 choices. 
<ol><li>Create a computed column.</li>
<li>Use Map feature. A tab on the bottom on any data item.</li>
</ol>

harrisonb

Hi, 
 
Thanks for your earlier reply but the client has now come back and stated that he wishes to have all the enrichment completed in Big Data Analytics, does that mean I am only limited to creating a computed column or is there something else I can do in either BDA or maybe its better to focus before it gets imported in Qloader? 
 
Thanks again, 
Harrison

micajblock

Not really my area of expertise, but if I am not mistaken QLoader has a decode function.