Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
calc_lookup_table_intersection [2011/07/25 16:26] hermann created |
calc_lookup_table_intersection [2015/10/12 16:30] (current) admin |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| ===== Inputs ===== | ===== Inputs ===== | ||
| - | ^ Name ^ Type ^ Description ^ | + | ^ Name ^ Type ^ Description ^ |
| - | | First Table | [[Lookup Table Type|Lookup Table ]] | The first lookup table. | | + | | First Table | [[Lookup Table Type]] | The first lookup table. | |
| - | | Second Table | [[Lookup Table Type|Lookup Table ]] | The second lookup table. | | + | | Second Table | [[Lookup Table Type]] | The second lookup table. | |
| ===== Optional Inputs ===== | ===== Optional Inputs ===== | ||
| - | ^ Name ^ Type ^ Description ^ Default Value ^ | + | ^ Name ^ Type ^ Description ^ Default Value ^ |
| - | | use First Table To Solve Duplicated Key | [[Bool Type|Bool ]] | 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, in the case of duplicated keys, the value of the first table is selected; otherwise, the value of the second table is selected. | True | |
| ===== Output ===== | ===== Output ===== | ||
| - | ^ Name ^ Type ^ Description ^ | + | ^ Name ^ Type ^ Description ^ |
| - | | result | [[Lookup Table Type|Lookup Table ]] | The resulting lookup table. | | + | | Result | [[Lookup Table Type]] | The resulting lookup table. | |
| ===== Group ===== | ===== Group ===== | ||
| Line 26: | Line 26: | ||
| ===== Notes ===== | ===== Notes ===== | ||
| + | |||
| + | The column names from the first input table are assigned to the output table. | ||
| For further information about set intersection, see [[wp>Set_intersection]]. | For further information about set intersection, see [[wp>Set_intersection]]. | ||