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 here.
- Import Manager and IIEP as defined in the Inbound Map Data - Transform topic of the Data Exchange documentation here.
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 in the Resource Materials online help here.
For places where STEP Functions can be used, refer to the STEP Functions topic in the Resource Materials online help here.
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 in the Resource Materials online help (here) and Matching, Linking, and Merging JavaScript Binds topic of the Matching, Linking, and Merging documentation.