Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
calc_lookup_table_intersection [2015/10/12 16:30] admin |
calc_lookup_table_intersection [2026/08/28 03:11] (current) hermann Sync from local documentation review |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Calc Lookup Table Intersection ====== | + | ====== Calc Lookup Table Intersection ====== |
| ===== Description ===== | ===== Description ===== | ||
| - | This functor calculates a lookup table that is the intersection of two lookup tables. | + | Calculates the lookup table that is the intersection of two lookup tables. |
| ===== Inputs ===== | ===== Inputs ===== | ||
| Line 14: | Line 14: | ||
| ^ Name ^ Type ^ Description ^ Default Value ^ | ^ Name ^ Type ^ Description ^ Default Value ^ | ||
| - | | Use First Table To Solve Duplicated Key | [[Boolean Value Type]] | If true, in the case of duplicated keys, the value of the first table is selected; otherwise, the value of the second table is selected. | True | | + | | Use First Table To Solve Duplicated Key | [[Boolean Value Type]] | If true, and a key occurs in both tables, the value from First Table is kept; if false, the value from Second Table is kept instead. | True | |
| - | ===== Output ===== | + | ===== Outputs ===== |
| ^ Name ^ Type ^ Description ^ | ^ Name ^ Type ^ Description ^ | ||
| - | | Result | [[Lookup Table Type]] | The resulting lookup table. | | + | | Result | [[Lookup Table Type]] | The resulting lookup table, containing only the keys present in both First Table and Second Table. | |
| ===== Group ===== | ===== Group ===== | ||
| - | [[Functor List#Table | Table]] | + | [[Functor List#Lookup Table | Lookup Table]] |
| ===== Notes ===== | ===== Notes ===== | ||
| - | The column names from the first input table are assigned to the output table. | + | The key and value column names of Result are inherited from First Table. |
| - | For further information about set intersection, see [[wp>Set_intersection]]. | + | For background on this operation, see [[https://en.wikipedia.org/wiki/Intersection_(set_theory)|set intersection]]. |
| ===== Internal Name ===== | ===== Internal Name ===== | ||