Batch Append Rows
Function Description
Supports appending multiple dataset records (rows) from the source datasource to corresponding datasets in the target datasource, enabling many-to-many batch appending. Requires identical field names and data types between source and target datasets for successful operation.
Application Scenarios
Suitable for merging various data types from two regions. For example, when a municipal land authority needs to integrate geographical national condition feature data from two counties, where each county's datasource contains 58 standardized datasets categorized by surface features. The batch append rows operation can simultaneously append all 58 datasets to their corresponding targets.
Feature Entry
- Data Tab->Data Processing->Vector->Batch Append Rows.
- Toolbox->Data Processing->Vector->Batch Append Rows.
Parameter Description
- Target Datasource: Select the target datasource to be appended.
- Source Datasource: Select the source datasource providing datasets.
- Set dataset mapping relationships in the list area:
- The system automatically matches datasets with identical names between source and target datasources. Users can modify mappings by clicking dataset names.
- When source datasets have no corresponding target datasets, the target dataset name appears empty. Checking these rows will copy the source dataset to the target datasource.
- Create New Fields: Determines whether to retain fields existing in source data but absent in target datasets. When checked, both matching and non-matching fields are preserved; otherwise only matching fields are retained.
Notes:- When target dataset is CAD: Source can be point/line/region/text/CAD datasets. For tabular targets: Source can be point/line/region/text/CAD datasets. Other dataset types require matching types between source and target (e.g., point-to-point).
- For spatial datasets (point/line/region/text), geometries will be appended. Tabular datasets only process attribute data.
- For SQLPlus datasources: If target dataset contains existing data with mapsheet index, manually delete and rebuild the index after appending.
Related Topics