Append Columns
Feature Description
The Append Columns feature adds new fields to the attribute table of the target dataset by extracting values from the source dataset's attribute table.
This operation requires setting a pair of connection fields (one from the source dataset and one from the target dataset). Data values can only be successfully appended when matching values exist in both specified connection fields.
Notes:
- The source dataset must contain fields that do not exist in the target dataset, otherwise the operation will fail.
- Connection fields may have different names but must share the same data type and contain matching values.
- Binary-type fields cannot be used as connection fields.
- Selected source fields for appending must be non-system fields and exclude the SmUserID field.
Parameter Description
| Parameter | Default | Description | Type |
|---|---|---|---|
| Target Dataset | Select the target dataset to append columns to | DatasetVector | |
| Connection Field | Matching field in target dataset | String | |
| Source Dataset | Select source dataset providing fields | DatasetVector | |
| Connection Field | Matching field in source dataset (must share same data type with target's connection field) | String | |
| Source Field Names to Append | Fields from source dataset to be appended | String | |
| New Field Names After Appending | Corresponding field names in target dataset (one-to-one mapping with source fields) | String |
Output
| Parameter | Description | Type |
|---|---|---|
| Result Dataset | Output dataset with appended columns | DatasetVector |