Join Attributes from a Table
- Author: V.Olaya (c) 2005, O.Conrad (c) 2011
- Menu: Table | Tools;Shapes | Attributes
Description
Joins two tables using key attributes.
Parameters
| Name | Type | Identifier | Description | Constraints |
Input | Input Table | table, input | TABLE_A | - | - |
Join Table | table, input | TABLE_B | - | - |
Output | Unjoined Records | table, output, optional | UNJOINED | Collect unjoined records from join table. | - |
Result | table, output, optional | RESULT_TABLE | - | - |
Result | shapes, output, optional | RESULT_SHAPES | - | - |
Options | Input Join Field | table field | ID_A | - | - |
Join Table Field | table field | ID_B | - | - |
Add All Fields | boolean | FIELDS_ALL | - | Default: 1 |
Fields | table fields | FIELDS | - | - |
Keep All | boolean | KEEP_ALL | - | Default: 1 |
Case Sensitive String Comparison | boolean | CMP_CASE | - | Default: 1 |
Command Line
Usage: saga_cmd table_tools 3 [-TABLE_A ] [-ID_A ] [-TABLE_B ] [-ID_B ] [-FIELDS_ALL ] [-FIELDS ] [-KEEP_ALL ] [-CMP_CASE ] [-UNJOINED ] [-RESULT_TABLE ] [-RESULT_SHAPES ]
-TABLE_A: Input Table
table, input
-ID_A: Input Join Field
table field
-TABLE_B: Join Table
table, input
-ID_B: Join Table Field
table field
-FIELDS_ALL: Add All Fields
boolean
Default: 1
-FIELDS: Fields
table fields
-KEEP_ALL: Keep All
boolean
Default: 1
-CMP_CASE: Case Sensitive String Comparison
boolean
Default: 1
-UNJOINED: Unjoined Records
table, output, optional
-RESULT_TABLE: Result
table, output, optional
-RESULT_SHAPES: Result
shapes, output, optional