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