Attribute Table Columns Order vs Geoprocessing Alphabetic Order

354
4
06-28-2021 12:19 PM
Status: Open
Labels (1)
mmartinezyordan
Occasional Contributor

Please let users always switch between how the columns order appears when using Geoprocessing tools. Sometimes some Geoprocessing toll will show you the attribute of a table in alphabetic order and sometimes in the same order as the table. Let us choose that.

4 Comments
KoryKramer

Depending on what tools you are referring to, this may be the same request as https://community.esri.com/t5/arcgis-pro-ideas/show-unsorted-field-names-in-arcgis-pro-delete-field-...   i.e. if it is any tool with the add multiple control, I believe it would be the same idea - but somebody from our geoprocessing team could confirm.

KoryKramer_0-1624909132938.png

 

Providing some examples of specific tools where you encounter the behavior could be helpful, too.

LindaGreen

I'll second this.

I run the intersect tool a lot. For example, I might intersect wetlands with site boundaries to get the acreage of a wetland associated with each site. 

The intersect file always has the fields ordered the way they were in the original file, with the fields from the "first" input appearing first and the "second" input appearing second. Field order -- both in the original files and in the intersected file -- is really important to my workflow and keeping things straight.

Sometimes I need to dissolve the outputs of these files. If I add the fields to the dissolve tool one at a time, I see the fields in their original order in the dropdown (yay!), but I have to click on the dropdown arrow, scroll down in the list, and click on the field, and I have to do that for every field I want to include in the dissolve. Sometimes our delineated wetland files have 30+ fields, so that's a lot of clicks and a lot of scrolling. 

If I use the "add many" drop-down, it's super fast to just click on each of the fields I want to use in the dissolve (yay!), except that the fields are sorted alphabetically, which is disorienting and makes it hard to tell which fields I want to include. 

It would be really helpful if we had a toggle switch that would let us sort fields alphabetically or by their original order, whether we were adding fields one at a time or many at a time. (Like the markups below, but more intuitive and less ugly).

fields.jpgfields2.jpg

I've run across this in the dissolve and delete fields GP tools (the other link mentioned Delete Fields only), but it looks like it's also in Split by Attributes and the field mapping for the Append tool ...  and probably other places I don't know to look. 

LindsayRaabe_FPCWA

It would be good if the "Add many" option which appears in many geoprocessing tools when dealing with fields had the option to change how the fields are sorted. At present using a tool (i.e. the Join Field tool) and you go to Transfer Fields section, you can either select individual fields from the provided drop down window (which are sorted as per the attribute table), or you can select "Add many" and check the boxes to add multiple fields, or all fields in a quick, easy manner. In my current use case, I'd like to preserve the ordering of the fields but when I use the Add many option, the fields are sorted alphabetically. I understand this can make it easier to find fields in long lists, but it would be good to choose what order the selected fields appear. 

LindsayRaabe_FPCWA_0-1642565720959.png LindsayRaabe_FPCWA_1-1642565725095.png

 

LindsayRaabe_FPCWA_2-1642566069976.png 

LindsayRaabe_FPCWA_3-1642566150522.png

 

 

LindsayRaabe_FPCWA

Thanks @KoryKramer for merging my idea with this one. I did do a search but obviously used the different words. I feel like this would be a "simple" (from a non-programmers pointless opinion) improvement that would make a big difference to a good number of people.