Append Columns
Feature Description
The Append Columns function primarily adds new fields to the attribute table of the target dataset. The field values are derived from the attribute table of the source dataset.
During the operation, a pair of connection fields must be specified - one from the source dataset and another from the target dataset. Data values can only be successfully appended when matching values exist in both connection fields.
Feature Entry
- Data Tab->Data Processing->Vector->Append Columns.
- Toolbox->Data Processing->Vector->Append Columns.
Parameter Description
- Target Dataset: Select the target dataset to append and choose its connection field.
- Source Dataset: Select the source dataset providing attribute fields and its connection field. The connection field type here must match that of the target dataset.
- Add Fields: Select fields to append to the target dataset.
Notes:- The source dataset must have fields that are not present in the target dataset; otherwise, the operation will fail.
- Connection fields can have different names but must share the same data type and contain matching values.
- The system automatically filters out fields existing in both datasets and system fields (SmUserID). Remaining user-defined fields will be listed for selection in the Add Fields list.
- Connection fields cannot be of long binary type.
- User-defined fields refer to non-system fields (all property fields except SmUserID).
- For SQLPlus datasources: If the target dataset contains existing data with mapsheet indexes, manually delete and rebuild mapsheet indexes after appending operations.
Related Topics