Function Description
Supports appending multiple dataset records (rows) from the source datasource to the corresponding datasets in the target datasource, achieving many-to-many batch appending. For the appending to succeed, the fields and their types in the attribute tables of the source dataset and target dataset must be identical.
Application Scenarios
Applicable for merging various types of data from two regions. For example, a city's land administration department plans to integrate geographic national condition element data from two counties. The data sources of the two counties store 58 datasets according to a unified surface classification standard. By performing the batch append rows operation, all 58 datasets can be simultaneously appended to their corresponding datasets.
Function Entry
- Data Tab -> Data Processing -> Vector -> Batch Append Rows.
Parameter description
- Target Datasource: Select the target datasource to be appended to.
- Source Datasource: Select the datasource that provides the datasets to be appended.
- In the list box area setting, set the correspondence for appending datasets; by checking the checkboxes, determine which datasets participate in the appending:
- The program automatically matches datasets with the same names in the source and target datasources. Users can also change the dataset correspondence by clicking the dataset name and selecting from the dropdown menu.
- If a dataset exists in the source datasource but no corresponding dataset exists in the target datasource, the target dataset name is displayed as empty. If the checkbox for that row is checked, the program will copy the dataset to the target datasource.
- Leave unmapped field: Used to specify whether to retain fields that exist in the source data but not in the target dataset; unchecked by default. If checked, the target dataset automatically creates new columns to save fields from the source dataset that match and do not match those in the target dataset. If unchecked, fields in the source dataset that do not match those in the target dataset will be ignored.
Notes:- If the target dataset is a CAD dataset, the source dataset can be a point, line, region, text, or CAD dataset. If the target dataset is a tabular dataset, the source dataset can be a point, line, region, text, or CAD dataset. For other types of target datasets, the source dataset must be of the same type as the target dataset to perform this operation; for example, a point dataset must be appended to point data.
- When operating on point, line, region, or text datasets, the geometry from the source dataset will also be appended to the target dataset. When operating on a tabular dataset, only the attribute table will be processed.
- For SQLPlus datasources, if data already exists in the target dataset and a mapsheet index has been created, it is recommended to manually delete the mapsheet index and rebuild it for the newly generated dataset after the appending operation.
Related Topics