[GIS] How to merge/combine several tables in geodatabase into one table using ModelBuilder

arcgis-desktopcsvfile-geodatabasemergemodelbuilder

I have over 50 csv files that have the same data structure and I need to merge them into one table.

As I need to build a model I have successfully imported all the files into a File Geodatabase.

How to I merge all these files into one table?

Best Answer

You may use the Merge tool:

Combines multiple input datasets of the same data type into a single, new output dataset. This tool can combine point, line, or polygon feature classes or tables.

Open you model drag in the Merge tool, double click on in and add the many gdb tables within the input parameter, define out name and location, and then save model.

Related Solutions

[GIS] Merge an entire Geodatabase in ESRI ModelBuilder

You can accomplish this using this python script, here is the syntax:

import arcpy
from arcpy import env
env.workspace = "C:\\temp\\test.gdb"
fcList = arcpy.ListFeatureClasses('','')
arcpy.Merge_management(fcList, "Merge")

Just change the env workspace to match your geodatabase path.

[GIS] How to merge multiple file geodatabases into one file geodatabase

First, welcome to the site!

To check your data back in you need to run Check-In (form the Data Manager Toolbar) for each of the AXF files. This will check modifications (edit, create & delete) back into the parent Geodatabase.

Note that if there are any conflicts, last in wins (ie, new data will overwrite existing data even if that data had changed since checkout). If this is a concern you should use replica geodatabases to check-out from and use ArcGIS Desktop tools to manage conflicts before committing edits to your original geodatabase.

Best Answer

Related Solutions

[GIS] Merge an entire Geodatabase in ESRI ModelBuilder

[GIS] How to merge multiple file geodatabases into one file geodatabase

Related Question