topic Re: Sort output labels by value ascending in Mapping Questions

Sort output labels by value ascending

AdrianJuarez — Tue, 28 Apr 2015 13:49:13 GMT

Looking for some input regarding the expression required to sort output labels (ascending) based off of a specific value. I have a table of ethnic population values for administrative districts (row) and ethnicities (column). I have attached a sample table for reference. Any help is greatly appreciated.

Re: Sort output labels by value ascending

SepheFox — Tue, 28 Apr 2015 15:37:42 GMT

Hi Adrian,

I'm not certain what you mean by "the expression required", but you can either sort by right clicking the field heading in the attribute table, or using the Sort tool: ArcGIS Desktop

Re: Sort output labels by value ascending

AdrianJuarez — Tue, 28 Apr 2015 16:01:02 GMT

Sorry for not going into greater detail. What I am trying to do is use a label expression via layer properties to sort through columns within my table then sort the output labels on my map based off of values ascending. I am aware of the sort ascending / descending within the table / feature class, I think what I am trying to do is a bit more than that.

Re: Sort output labels by value ascending

SepheFox — Tue, 28 Apr 2015 16:09:24 GMT

Did you look at the Sort tool I mentioned? It creates a new feature class which is already sorted.

Re: Sort output labels by value ascending

DarrenWiens2 — Tue, 28 Apr 2015 16:29:06 GMT

You are talking about sorting columns, not rows, correct? For example, in your spreadsheet, "Armenian" would always come first.

Re: Sort output labels by value ascending

AdrianJuarez — Tue, 28 Apr 2015 17:13:43 GMT

Darren, I have attached an example of my current labeling expression and what my labeling currently looks like.

" Armenian: " & [Armenian_M2] &vbnewline& "Aromenian:" & [Aromenian_M2] &vbnewline&...etc

Armenian: 5%

Aromenian: 12%

Greek: 30%

Macedonian: 2%

This is what my output labels need to look like and I would like to use the label expression to make it happen. Sorted by values descending

Greek: 30%

Aromenian: 12%

Armenian: 5%

Macedonian: 2%

Re: Sort output labels by value ascending

AdrianJuarez — Tue, 28 Apr 2015 17:15:11 GMT

We are only licensed at the basic level within the org I currently support. I am going to try this at home later tonight. Thanks for the info.

Re: Sort output labels by value ascending

SepheFox — Tue, 28 Apr 2015 17:28:41 GMT

Oh, now I see what you are trying to do! It looks like these folks did just that, using a field called "top_depth_inches" to sort the label: Displaying a multi-row table label in ArcGIS using Python | wolfmapper