Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
calculate_lookup_table_keys_and_values [2026/07/07 16:10]
hermann
calculate_lookup_table_keys_and_values [2026/07/15 01:21] (current)
hermann
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 [[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. |+| 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 =====
Line 62: Line 62:
  
 ''​CalculateLookupTableKeysAndValues''​ ''​CalculateLookupTableKeysAndValues''​
 +