Standard lookup

This is a standardized lookup table where you can store multiple dimensions of lookup parameters. You can then retrieve any combinations of these dimensions as input into the target cells. If you are looking up two normalized parameters, then standard tables provide the most efficient lookup tool. You can set up input pipes that look up within ranges of values rather than matching values. When you use a range lookup, the field represents the lower limit of the range. For additional information, refer to Input pipe range lookups.

Once you have created the data source, use the process below to complete the definition of a standard lookup input pipe.

In most cases, the mapping you perform when defining a standard lookup input pipe maps from fields in the data source to fields in the destination table. However, you can create a “relational” input pipe mapping in which you join the destination table to a related table. In this case, you provide a field from the destination table that creates the join between the tables. Refer to Relational input pipes for additional information.

Define a standard lookup input pipe

1. Select “Standard Lookup” as the Lookup Method.
2. Select the Data Source Field from the data source that contains the value to be populated.
3. If you have not already done so, select the Destination Field into which the input pipe data will be populated.
4. You can optionally enter a Default Destination Value. This value is used when the mapping to an entry in the Data Source fails. In some cases, you can enter INF as the Default Destination Value to prevent records with failed mappings from being included in the run. Refer to Using INF for input pipe cost fields for additional information.
5. Click Add Mapping Field to define the mapping between the data source and the model table using Map From Data Source Field - Map To Table - Map To Table Field combinations. Each row you create represents a relationship between a source and a destination field.