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

Table

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