Select to view content in your preferred language

Attribute Table Columns Order vs Geoprocessing Alphabetic Order

2556
15
06-28-2021 12:19 PM
Status: Implemented
Labels (1)
MiguelMartinezYordan
Occasional Contributor II

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.

15 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. 

JonathanNeal
Status changed to: In Product Plan

FYI, this is completed for our upcoming 3.1 release. Thank you all for your feedback.

Details:

For field dropdown lists, we added options on which fields were available and how they are displayed.

JonathanNeal_1-1667504171200.png

For multivalue controls we added the same options if it is a field type, and also added a search control to the AddManyPopup for those with LOTS of fields this will hopefully save you time.

Filtered to show field aliases:

JonathanNeal_2-1667504537298.png

Filtered to show field names:

JonathanNeal_3-1667504685758.png

LindsayRaabe_FPCWA

@JonathanNeal Excellent. Looking forward to seeing it! Do you have a rough release date fort 3.1?

KoryKramer

@LindsayRaabe_FPCWA we're looking at February 2023 for the 3.1 release.

LindsayRaabe_FPCWA

@KoryKramer thanks!

AmeliaBradshaw
Status changed to: Implemented

This Idea has been implemented in ArcGIS Pro 3.1. Please see the What's New documentation for more new features in Pro 3.1.

The Ideas in ArcGIS Pro 3.1 blog will be wrapped up soon, highlighting all Ideas implemented in this release, including this one. Once complete, I will add the link to this comment. 

LindsayRaabe_FPCWA

@AmeliaBradshaw the "What's New documentation" link you provided above doesn't work for me.