Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
calculate_lookup_table_keys_and_values [2026/07/04 23:56] hermann |
calculate_lookup_table_keys_and_values [2026/07/15 01:21] (current) hermann |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| ^ Name ^ Type ^ Description ^ | ^ Name ^ Type ^ Description ^ | ||
| - | | Key Column Expression | [[Image Expression Type]] | The formula evaluated for each row to produce the output key, written using the [[Image Expression Type|image expression editor]]. Must be enclosed in square brackets ''[ ]'' in EGO Script. | | + | | Key Column Expression | [[Image Expression Type]] | The formula evaluated for each row to produce the output key. Must be enclosed in square brackets ''[ ]'' in EGO Script. | |
| - | | Value Column Expression | [[Image Expression Type]] | The formula evaluated for each row to produce the output value, written using the [[Image Expression Type|image expression editor]]. Must be enclosed in square brackets ''[ ]'' in EGO Script. | | + | | Value Column Expression | [[Image Expression Type]] | The formula evaluated for each row to produce the output value. Must be enclosed in square brackets ''[ ]'' in EGO Script. | |
| ===== Optional Inputs ===== | ===== Optional Inputs ===== | ||
| Line 20: | Line 20: | ||
| | Key Column Name | [[Name Type]] | None | Name of the key column in the output lookup table. If omitted, the corresponding name from the base table is used. | | | Key Column Name | [[Name Type]] | None | Name of the key column in the output lookup table. If omitted, the corresponding name from the base table is used. | | ||
| | Value Column Name | [[Name Type]] | None | Name of the value column in the output lookup table. If omitted, the corresponding name from the base table is used. | | | Value Column Name | [[Name Type]] | None | Name of the value column in the output lookup table. If omitted, the corresponding name from the base table is used. | | ||
| - | | Base Lookup Table | [[Lookup Table Type]] | None | The lookup table whose row set drives iteration. When not provided, the lowest-indexed connected [[Number Table]] (verbose form) or the first lookup table referenced by name in the expression (abbreviated form) is used — not a union of all connected tables. | | + | | Base Lookup Table | [[Lookup Table Type]] | None | The lookup table whose row set drives iteration. When not provided, the [[Number Table]] hook with the lowest list index that is connected to a **lookup table** (not a regular table) is used as the row source (verbose form), or the first lookup table referenced by name in the expression (abbreviated form) — not a union of all connected tables. Prefer this port over a ''Number Table'' hook when the table is needed only to define the row set and is not referenced in the expression, to keep abbreviated syntax available. | |
| ===== Output ===== | ===== Output ===== | ||