Lookup Tables can be used as a transformation, within STEP Functions, as well as in JavaScript. Each of these options is discussed in the following sections.
In Transformations
The following transformations provide access to transformation lookup tables:
- Replace whole value using Lookup Table - replaces the entire attribute value or text string
- Replace words using Lookup Table - replaces specific words in an attribute value or text string
The lookup table transformations are available within:
- Attribute Transformations as defined in the Attribute Transformations topic of the System Setup documentation.
- Import Manager and IIEP as defined in the Inbound Map Data - Transform topic of the Data Exchange documentation.
In STEP Functions
The following STEP Functions provide access to transformation lookup tables for example, for use in calculated attributes:
- replacevaluebylookup(asset-id, value) - replaces the entire value or text string
- replacewordbylookup(asset-id, value) - replaces specific words in an value or text string
Both take the ID of the desired lookup table as the first argument, and the string / value to work on as the second argument.
For more information on the lookup table functions, refer to the Other Functions topic.
For places where STEP Functions can be used, refer to the STEP Functions topic.
In JavaScript
The following JavaScript Bind provides access to transformation lookup tables for example, for use in business rules and in matching, linking, and merging:
- Lookup Table Home
For information, refer to the Other Binds topic and the Using JavaScript with Lookup Tables topic.