Latest Contributions by MicahBabinski

Hi Zachary, Would Cluster_Plot = '"{}-{}"'.format(i,'!OBJECTID!')‍ work? I've become a big fan of using triple quoted strings and the .format() method when creating a variable to use as a field calculator expression. Another option is to use an update cursor. Something like: table = "myTable" fields = ("OBJECTID", "PLOT_ID") i = 1 with arcpy.da.UpdateCursor(table, fields) as cursor:     for row in cursor:         row[1] = str(i) + "-" + str(row[0])         cursor.updateRow(row)         i+=1‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Good luck! ... View more

Good morning Benjamin, Do the tables all have the same schema? If not, are you doing any kind of field mapping for your merge? I am not 100% sure how the merge tool works when no field mapping info is supplied, but I am thinking it may be adding the fields of each input table into the output, which could be hurting your performance. You may wish to create your output table ahead of time, and then use iteration to append the input tables. Something along the lines of: import arcpy arcpy.env.workspace = "C:\\DeleteMe\\tomerge\\tables.gdb" target_table = "C:\\DeleteMe\\output\\final.gdb\\target_table" tblList = arcpy.ListTables() for t in tblList:     arcpy.Append_management([t], target_table, "NO_TEST")‍‍‍‍‍‍‍‍ I was using the Append tool a couple weeks ago to append 60+ feature classes to one target. I think it took about ten minutes. Good luck! Micah ... View more

Thank you all very much for your input! In the end I only needed a table with three fields: From there I wrote the following script (as it would be implemented in a script tool): # Name: appendWithFieldMap.py # Author: Micah Babinski # Date: 9/8/2016 # Description: Appends features to an output feature class using field mapping information stored in a table # # USAGE NOTE: The table must contain three columns #           1. SourceTablepath (fully-qualified path to the source feature class #           2. SourceFieldName (name of the input field as it appears in the source feature class #           3. DestinationFieldName (destination field name as it appears in the destination feature class) import arcpy import sys # obtain user parameters outputFeatureClass = arcpy.GetParameterAsText(0) #r"W:\FieldMappingResearch\gdb\Output.gdb\roads" fieldMapTable = arcpy.GetParameterAsText(1) #r"W:\FieldMappingResearch\gdb\Inputs.gdb\fieldMapTable" # list the fields which contain the field map info fields = ["SourceTablePath", "SourceFieldname", "DestinationFieldName"] # define function to get unique field values from a table def GetUniqueFieldValues(table, field):     """     Retrieves and prints a list of unique values in a user-specified field     Args:         table (str): path or name of a feature class, layer, table, or table view         field (str): name of the field for which the user wants unique values     Returns:         uniqueValues (list): a list of the unique values in the field     """     # get the values     with arcpy.da.SearchCursor(table, [field]) as cursor:         return sorted({row[0] for row in cursor}) # get a list of unique input feature classes arcpy.AddMessage("Listing the unique input feature classes.") inputs = GetUniqueFieldValues(fieldMapTable, "SourceTablePath") # get a list of unique output fields arcpy.AddMessage("Listing the unique output fields.") outputFields = GetUniqueFieldValues(fieldMapTable, "DestinationFieldName") # create an empty field mappings object arcpy.AddMessage("Creating an empty field mappings object.") fm = arcpy.FieldMappings() # build the field mappings object arcpy.AddMessage("Building the field mappings object.") for f in outputFields:     arcpy.AddMessage("\t" + f + "...")     # create a field map object     arcpy.AddMessage("\t...Creating a field map object.")     fMap = arcpy.FieldMap()     with arcpy.da.SearchCursor(fieldMapTable, fields, """{0} = '{1}'""".format("DestinationFieldName", f)) as cursor:         for row in cursor:             # add the input field to the field map             arcpy.AddMessage("\t...Adding " + row[1] + " as an input field.")             fMap.addInputField(row[0], row[1])     # set the output name     arcpy.AddMessage("\t...Setting the output name.")     outputFieldName = fMap.outputField     outputFieldName.name = f     fMap.outputField = outputFieldName         # add the field map to the field mappings object     arcpy.AddMessage("\t...Adding the field map to the field mappings object.")     fm.addFieldMap(fMap) # perform the append arcpy.AddMessage("\nAppending!") arcpy.Append_management(inputs, outputFeatureClass, "NO_TEST", fm) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ To summarize, the workflow was: Obtain a unique list of input feature classes (full paths, for use in the append GP tool) Obtain a unique list of the output fields (one arcpy.FieldMap() object is needed per output field) Create an empty field mappings object For each output field, create an empty field map object, obtain the input fields for that output field with a da.SearchCursor, add those to the field map object, set the name of the output field, and add the field map to the field mappings object I imagine that there is a lot more that could be done with this in terms of validation and error handling (for when field types are mismatched) but I think this will get me what I need. Thanks again! Micah ... View more