Append Rows

Function Description

This function is used to append data from one or multiple datasets to another dataset.

Applicable Datasets: point/line/region/text/CAD/model dataset, tabular dataset. Currently, network/route datasets are not supported for appending.

Function Entry

  • Data tab -> Data Processing -> Vector -> Append Rows.
  • Toolbox -> Data Processing -> Vector -> Append Rows.
  • In the workspace manager, select a dataset and drag it directly onto another dataset, or select multiple datasets and drag them onto another dataset, to pop up the Append Rows dialog box.

Parameter Description

  • Target Dataset: Select the target dataset for appending, which can be an existing dataset or manually create a new dataset for appending.
  • Source Dataset: Select the source dataset, which provides the data. The datasets in the list box can be edited using toolbar buttons. Click the Add button to pop up the Select dialog box, through which you can select datasets to append. Here, you can add one dataset as the source data or add multiple datasets simultaneously.
  • Field Mapping: Used to set the mapping relationship between fields of the source dataset and the target dataset. When a dataset is selected in the source data table, the mapping table will automatically display its field associations with the target dataset. Fields with the same name will be automatically matched. If the fields do not match, you can manually select the corresponding field from the dropdown list in the target field column.
    • Add: Click the Add button to add fields not yet in the table to the table.
    • Delete: Select one or more records in the table, and click the Delete button to delete them.
    • Import: Supports exporting the configured mapping relationship to a TXT file.
    • Export: Supports directly importing an existing TXT file, and after import, the mapping relationship stored in the file is read directly.
      Note:

      If the types of two corresponding fields are different, for example, mapping a text field (not pure numbers) to a numerical field, it cannot be correctly mapped to the target dataset field. This field will exist as a new field in the target dataset.

  • Leave Unmapped Field: Used to specify whether to retain fields in the source dataset that have no mapping relationship with the target dataset, unchecked by default. If checked, the target dataset automatically creates new columns to save unmapped fields from the source dataset. If unchecked, fields in the source dataset that are not mapped to the target dataset will be ignored.
  • Keep Same Name Material: Used to set whether to retain materials with the same name in the model dataset. During the data appending process, when there is a material with the same name in the source model dataset and the target model dataset, if keep same name material is selected, the material in the target model dataset is retained after renaming; if keep same name material is not selected, only the material from the source model dataset is retained, and the material with the same name in the target dataset is deleted.

Note:
  • If the target dataset is a CAD dataset, the source dataset can be point/line/region/text/CAD dataset; if the target dataset is a tabular dataset, the source dataset can be point, line, region, text, or CAD dataset; if the target dataset is another type, the source dataset must be of the same type to perform this operation, for example, a point dataset must be appended with point data.
  • When operating on point, line, region, or text datasets, the geometry of the source dataset will also be appended to the target dataset. When operating on a tabular dataset, only the attribute table will be operated on.
  • For SQLPlus data sources, if data already exists in the target dataset and a mapsheet index has been created, after the appending operation, it is recommended to manually delete the mapsheet index and rebuild it for the newly generated dataset.

Related Topics

Append Columns

Batch Append Rows

Merge Datasets

Dissolve