Useful when you don’t have the data immediately and need to lookup the value in a codeset.
There are various options for performing lookups:
codemap
When you need to validate and normalize field values against code sets, you can use lookup functions to execute the mapping. If these lookups are done across various interfaces, they are best stored in shared modules.
Check out the codemap module in the Iguana Tools repository to see how you can:
Confirm an incoming value is contained in a code set.
Translate from one value or code set to another.
Map data fields using codemap.lua: http://help.interfaceware.com/v6/codemap-example
External - Query a Database or API
Useful when you don’t have the data within the current system; can look them up elsewhere.
If you don’t want to store mappings in functions, you have other options, such as pulling in an external xml file containing mappings into the Translator. Web services and database lookups are also common.
Load and save a http://help.interfaceware.com/v6/load-and-save-a-fil