topic Re: How to sort a Table Frame on a Field not being actively shown in ArcGIS Pro Questions

How to sort a Table Frame on a Field not being actively shown

KateNewell1 — Fri, 30 Nov 2018 21:33:59 GMT

I have a table frame that I have added to my ArcGIS Pro layout. I need to sort the information on a number field that I am not actively displaying on the map in the Table Frame. Only the fields that are showing in the Table Frame are allowed to be sorted on as far as I can tell? Would be really helpful if you could sort on fields in the table regardless of whether or not they are displayed. Maybe I'm missing something?

Re: How to sort a Table Frame on a Field not being actively shown

DanPatterson_Retired — Fri, 30 Nov 2018 21:39:22 GMT

did you try sorting then hiding the field? never had a use case for your workflow, but maybe it might work

Re: How to sort a Table Frame on a Field not being actively shown

KateNewell1 — Fri, 30 Nov 2018 21:46:22 GMT

That is a good idea! I tried it but when I sorted and then hid the field, it reverted back to the old sorting.

I have alpha-numeric data I am sorting on. I created a new field that is numeric to sort the table/legend but don't want to display the numeric information (SA_NUM needs to be used to sort but not shown on layout. See below:

Re: How to sort a Table Frame on a Field not being actively shown

KateNewell1 — Fri, 30 Nov 2018 21:49:41 GMT

I guess another workaround would be to use the "Sort" tool in Data Management. Seems like more work and a new table creation than should be necessary but could work.

Re: How to sort a Table Frame on a Field not being actively shown

DanPatterson_Retired — Fri, 30 Nov 2018 21:54:25 GMT

or maybe just uncheck its visibility once sorted

Re: How to sort a Table Frame on a Field not being actively shown

KateNewell1 — Fri, 30 Nov 2018 21:57:23 GMT

That is what I did and it reverted to the old sorting.

Re: How to sort a Table Frame on a Field not being actively shown

KoryKramer — Mon, 03 Dec 2018 23:52:07 GMT

Hi Kate, I reviewed the idea that you posted. Allow sorting on any field in Table Frames

It's a totally valid idea.

While I was playing with this, though, I thought I might offer a quick workaround.

Could you just place the column used for sorting outside of the page?

So you would see this in Pro:

And when you export it, you end up with:

Just a thought so that you don't have to run the Sort gp tool etc. etc.

Re: How to sort a Table Frame on a Field not being actively shown

KateNewell1 — Tue, 04 Dec 2018 00:10:48 GMT

Thanks Kory! Yep that could work too. I have a set of tasks that run to create the legend tables, so adding the sort at the end of the tasks worked too. Just seemed like a simple tweak to the table frames that could make them more powerful/productive

Thanks!

-Kate

Re: How to sort a Table Frame on a Field not being actively shown

Mark_Johnson — Wed, 22 Jan 2020 16:09:42 GMT

What worked for me was leaving the sort column(s) visible in the table frame, turning off Auto Width, then setting the column width(s) to zero (makes it 0.0001 actually), then the "hidden" columns can be used in the table frame Sorting rules.

(I also up-voted your Idea, IMO logically it should default to how the table view is sorted)

Re: How to sort a Table Frame on a Field not being actively shown

JordanSeider — Mon, 05 Dec 2022 19:48:00 GMT

Thanks for this suggestion! When I went to 0.0001 width, though, it still showed the first letters so I changed the font to have a clear colour.

Really hope ESRI can implement this in future updates.

Re: How to sort a Table Frame on a Field not being actively shown

CoreGeoscience_Services_Inc_ — Tue, 31 Oct 2023 19:24:32 GMT

Another option for ordering your table is to create a new one. Order the columns exactly how you want them and order the features exactly how you want them. Unfortunately you have to create a brand new table if there is any change to the order, but it does seem to work.