idea Attribute Table Columns Order vs Geoprocessing Alphabetic Order in ArcGIS Pro Ideas

Attribute Table Columns Order vs Geoprocessing Alphabetic Order

MiguelMartinezYordan — Mon, 28 Jun 2021 19:21:21 GMT

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.

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

KoryKramer — Mon, 28 Jun 2021 19:39:15 GMT

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-tool/idi-p/940783 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.

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

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindaGreen — Thu, 08 Jul 2021 04:59:51 GMT

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

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.

Include option to sort "Add many" options either by field order or alphabetically

LindsayRaabe_FPCWA — Wed, 19 Jan 2022 04:22:41 GMT

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.

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindsayRaabe_FPCWA — Thu, 20 Jan 2022 00:15:44 GMT

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.

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order - Status changed to: In Product Plan

JonathanNeal — Thu, 03 Nov 2022 21:01:27 GMT

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.

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:

Filtered to show field names:

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindsayRaabe_FPCWA — Fri, 04 Nov 2022 00:49:19 GMT

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

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

KoryKramer — Fri, 04 Nov 2022 12:32:41 GMT

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

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindsayRaabe_FPCWA — Mon, 07 Nov 2022 02:41:11 GMT

@KoryKramer thanks!

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order - Status changed to: Implemented

AmeliaBradshaw — Fri, 10 Mar 2023 13:45:04 GMT

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.

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindsayRaabe_FPCWA — Fri, 10 Mar 2023 07:11:27 GMT

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

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

KoryKramer — Fri, 10 Mar 2023 13:45:40 GMT

@LindsayRaabe_FPCWA it looks like that was the dev link. Should be all sorted now - we updated the link to https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindsayRaabe_FPCWA — Wed, 15 Mar 2023 00:58:57 GMT

Thanks @KoryKramer

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

MiguelMartinezYordan — Mon, 20 Mar 2023 13:41:02 GMT

Hi Kory,
Question, is there a way to migrate my ESRI Community posts from my current account (miguel.martinez2) to my new account: miguel.martinez ???

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

LindsayRaabe_FPCWA — Tue, 21 Mar 2023 00:07:17 GMT

@MiguelMartinezYordan Check out this page: Solved: Transfer Geonet Content to Different Account - Esri Community

Re: Attribute Table Columns Order vs Geoprocessing Alphabetic Order

JesseCloutier — Thu, 23 Mar 2023 16:11:52 GMT

@MiguelMartinezYordan When you have a moment, please send your request to our Esri Community team at esricommunity@esri.com and we'll be happy to look into what's possible when it comes to getting your past posts into your new account.