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