What Is the Append Tool?
The Append Tool adds data from one or more sources and puts it into an existing target data set.
It’s very similar to the Merge Tool but appending does not create a new data set.
Instead, it simply takes an existing dataset and combines the source data into this target dataset.
This tool allows for any type of features such as points, lines, polygons, and tables.
Setting a Field Map
When you append the geometry from one feature into an existing one, the Field Map allows you to set which attributes combine into the target.
Because your target dataset will have an existing schema, it’s how you control and even force attributes to match the target dataset.
But this also introduces an error common while merging or appending data. When you have two different field types like string and double, you cannot force these two types of fields together.
Common errors and troubleshooting
If you use the Append Tool, you can encounter errors associated with this operation. Here are some of the common errors and how to troubleshoot them.
Field Values – Appending one or more datasets into an existing target dataset will try to combine any fields with the same name. But if one field is a string and the other is numeric, you may get Error 001156 in ArcGIS. This is also true if the input surpasses the target field length. You can fix this error by assigning your field a new type of field. For string fields, you may have to add more length for characters.
Missing Output – If the appending dataset has missing features, this can happen if you accidentally select features before running the tool. To fix this, you can deselect the features from your input dataset and run the process again.
Invalid Shape Types – You cannot append different types of geometry. If you still want to append the data, you can try to convert from points, lines, or polygons into a common geometry type.
You can try troubleshooting 999999 errors in ArcGIS, which is a generic error code. The error code 999998 is an operating system error. Often, you can fix this error by removing background processing in your geoprocessing options.
What are some examples of using the Append Tool?
The most prominent usage of the Append Tool is when you have a larger dataset and you just want to keep adding data to it.
- If teams are collecting samples everyday with the same schema, they can dump the data into a core dataset by running the Append Tool.
- A group is collecting customer information. They can append their data collection like name, phone number and address into a larger customer database.
Keep in mind that it’s always good practice to perform quality control on your results. For data entry, collectors have to follow consistent rules with domains and default values.
How to run the Append Tool in ArcGIS and QGIS
In ArcGIS and ArcGIS Pro, the Append Tool is in the Data Management Toolbox and within the General Toolset.
In QGIS 3, you can find this tool as a plugin as Append Features to Layer.
The main difference is how you can dynamically match fields from the input to the target dataset in the field map.
The Append Tool is similar to the Merge Tool. But when you append data, it adds it to an existing dataset.
But merging takes two or more existing data sets and combines them creating a new data set.
What are some ways that you use the Append Tool? What errors have you encountered?
Do you have any questions? Please let us know with a comment below.