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
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