Append Rows
Function Description
Appends data from one or multiple datasets to another dataset.
Applicable Datasets: Point/Line/Region/Text/CAD/Model datasets, tabular datasets. Network/Route datasets are currently not supported.
Feature Entry
- Data Tab->Data Processing->Vector->Append Rows.
- Toolbox->Data Processing->Vector->Append Rows.
- In Workspace Manager, drag a dataset onto another dataset, or select multiple datasets and drag them onto a target dataset to open the Append Rows dialog.
Parameter Description
- Target Dataset: Select the target dataset for appending. This can be an existing dataset or a newly created dataset.
- Source Dataset: Select source datasets providing data. Use the Add button to select datasets through the Select dialog. Multiple datasets can be added simultaneously.
- Create New Fields: Determines whether to retain non-matching fields from source data. When enabled, fields existing in source datasets but not in the target will be preserved. When disabled, only fields matching the target dataset will be retained. Example: If target dataset NewDataset1 has field F1 and source dataset NewDataset2 has field F2 (other fields identical), enabling this option preserves both F1 and F2; disabling retains only F1.
- Keep Same Name Material: Determines handling of materials with identical names in model datasets. When enabled, materials with same names in both source and target model datasets will be renamed and preserved in the target. When disabled, only source materials are retained, overwriting target materials with same names.
Notes:- When target is a CAD dataset: Source can be Point/Line/Region/Text/CAD datasets. For tabular targets: Sources can be Point/Line/Region/Text/CAD. Other dataset types require source and target to be identical (e.g., Point datasets can only append Point data).
- For geometry datasets (Point/Line/Region/Text), geometries will be appended. For tabular datasets, only attribute operations are performed.
- For SQLPlus datasources: If target dataset contains existing data with mapsheet index, manually delete and rebuild the index after appending.
Related Topics