Calculate Lookup Table Keys And Values
Description
This functor generates a new lookup table from other tables, using one expression to define the new keys and another to define the new values.
Inputs
| Name | Type | Description |
|---|---|---|
| Key Column Expression | Image Expression Type | Expression describing how the value of each new key should be calculated. |
| 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 key and value generation expressions will be called. If this table is not provided, the first lookup table present in the list of input tables 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 input table used as format, a key-value pair will be created and inserted into the resulting table. If the generated key is equal to a previously generated key, the new generated value will be used to replace the existing value. 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 keys and values of the resulting lookup table.
Internal Name
CalculateLookupTableKeysAndValues