I'm am creating a script that will allow a user to add XY coordinates to a point layer, then export (along with any addition user selected fields) to Excel. I am getting stuck on the iteration of the selected fields and how to map them to prepare to export to Excel. I have a parameter that derives the field names from the input point layer and the user can tick each field they wish to include in the Excel export.
[GIS] Export selected fields in ArcGIS to Excel using Python
arcgis-10.2arcgis-desktopexcelfield-mappingpython
Related Solutions
This happens to me as well. I just run the model to that point. Then I select the join fields and run again. Ensure Geoprocessing options > overwrite is one and that seems to work. It then works always going forward.
For that you only need ability to 're-order' fields in one of the tables, e.g. going from:
to:
You can do it inside tool validation:
def updateParameters(self):
"""Modify the values and properties of parameters before internal
validation is performed. This method is called whenever a parameter
has been changed."""
for i in range(2):
if self.params[i*3].altered and not self.params[i*3+2].altered:
fromLYR=self.params[i*3].value
newList=[f.name for f in arcpy.ListFields(fromLYR)]
self.params[i*3+2].value = newList[:]
return
These are the parameters I use:
Best Answer
I found that I simply needed to split the field selections and then iterate through the list using field mapping.