Calculate Lookup Table Values

Description

This functor generates a new lookup table using keys from a base table and calculating values from a specified expression that can reference other tables and values.

Inputs

Name	Type	Description
Value Column Expression	Image Expression Type	Expression describing how each new value should be calculated.

Optional Inputs

Name	Type	Description	Default Value
Key Column Name	Name Type	Name of the key column. If omitted, the corresponding name from the table used as format will be used.	None
Value Column Name	Name Type	Name of the value column. If omitted, the corresponding name from the table used as format will be used.	None
Base Lookup Table	Lookup Table Type	Lookup table that, if provided, determines for which entries the value generation expression will be called. If this table is not provided, the table in the list of input tables with the smallest identifier value will be used.	None

Output

Name	Type	Description
Result	Lookup Table Type	Lookup table calculated from the input tables and values.

Group

Table

Notes

For each key present in the base lookup table, a key-value pair will be created and inserted into the resulting table. Keys are preserved from the base table, while values are calculated using the provided expression. The values of the key and value columns from the table used as format will be accessible during calculation as “line” and “column”, respectively, in the expressions for calculating values of the resulting lookup table.

Internal Name

CalculateLookupTableValues