Latest Contributions by DrewFlater

This kind of "merging" of multiple rows is typically done in the Summary Statistics tool, but there is not yet an option for concatenating values with a delimiter, though there is an enhancement logged that you can track ENH-000133689, also please comment and vote on the ArcGIS Ideas site: https://community.esri.com/t5/arcgis-pro-ideas/arcgis-pro-2-6-a-geoprocessing-tool-to-concatenate/idi-p/941105 ... View more

Hi @DuncanHornby  the improved performance statement refers to the loading/opening of a toolbox with many tools, as well as the access of those tools' properties and parameters, when a particular tool is opened. Tool execution is not impacted by the new format. ... View more

You can get info about the tool properties by right clicking a tool and select Properties, then go to the Parameters page.    The Detect Feature Changes tool uses a value table parameter with two string columns.   Use some code like this to have two parameter for picking the base and update layers, and a value table to pick the matching fields from the two datasets def getParameterInfo(self): """Define parameter definitions""" p1 = arcpy.Parameter(displayName="Input Base Features", name="base_Features", datatype="GPFeatureLayer", parameterType="Required", direction="Input") p2 = arcpy.Parameter(displayName="Input Updated Features", name="updated_Features", datatype="GPFeatureLayer", parameterType="Required", direction="Input") p3 = arcpy.Parameter(displayName="Compare Fields", name="compareFields", datatype="GPValueTable", parameterType="Optional", direction="Input") p3.columns = [['GPString', 'Base Fields'], ['GPString', 'Updated Fields']] params = [p1,p2,p3] return params def isLicensed(self): """Set whether tool is licensed to execute.""" return True def updateParameters(self, parameters): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" if parameters[0].valueAsText and parameters[1].valueAsText: desc_b = arcpy.Describe(parameters[0].value) desc_u = arcpy.Describe(parameters[1].value) parameters[2].filters[0].list = [field.name for field in desc_b.fields] parameters[2].filters[1].list = [field.name for field in desc_u.fields] return results like this:   ... View more