Transformation Lookup Tables

Transformation Lookup Tables are a type of asset in STEP where a defined set of From-To text mappings allows the 'from' text to be replaced with the 'to' text. Lookup tables can be used to perform normalization operations during tabular format imports, within STEP Functions, and within JavaScript used throughout STEP.

Note: Transformation Lookup Table definitions can be exported as comments and submitted to an external source control system for comparison purposes. For details, refer to the Configuration Management documentation here.

Setup Requirements

Setting up and using lookup tables involves the following steps:

  1. Create a new lookup table as described in Creating a Transformation Lookup Table here.
  2. Configure a lookup table as described in Configuring a Transformation Lookup Table here.

Additional Information

The following information is useful once a lookup table is set up:

  1. Understand where transformation lookup tables can be implemented as described in Using Transformation Lookup Tables here.
  2. Understand dimension dependency on transformation lookup tables as described in Dimension Dependencies and Transformation Lookup Tables here.
  3. Review an example of a Transformation Lookup Table used to transform words when importing tabular-based data as described in Transformation Lookup Table Example here.