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]]. |