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

574
8
11-30-2018 01:33 PM
KateNewell1
Occasional Contributor

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?

Reply
0 Kudos
8 Replies
DanPatterson_Retired
MVP Esteemed Contributor

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

Reply
0 Kudos
KateNewell1
Occasional Contributor

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:

Reply
0 Kudos
KateNewell1
Occasional Contributor

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.

Reply
0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

or maybe just uncheck its visibility once sorted

Reply
0 Kudos
KateNewell1
Occasional Contributor

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

Reply
0 Kudos
KoryKramer
Community Moderator

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.

KateNewell1
Occasional Contributor

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

Reply
0 Kudos
Mark_Johnson
New Contributor II

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)