topic Re: Query table for top 10 results in ArcGIS Pro Questions

Query table for top 10 results

ChrisPopham — Tue, 08 Sep 2020 14:17:19 GMT

I'm trying to automate map production with an ArcGIS Pro Layout, I need a table frame in the Layout to be of a predictable size/shape. They layer that will be displayed in the table is a series of points, essentially XYZ data. For consistency's sake, I just want to query and display the top 10-20 Z valued points in the table. I can't handpick the points, it needs to be scripted/automated. So far, I've not figured out a 'Top 20' query. (Arcade seems to have a 'TOP()' function but I can't make it work?!

Any Ideas???

Re: Query table for top 10 results

KoryKramer — Tue, 08 Sep 2020 18:20:38 GMT

Have you looked into the Sort option? Add and modify table frames—ArcGIS Pro | Documentation

If the table frame were set to show only 10 (or 20) records, the size of the frame shouldn't need to change, but if you point it at new data with the same schema, I would think that if you have Sort set up on a field, then the table in the layout would show the top 10 or 20 records.

Re: Query table for top 10 results

ChrisPopham — Tue, 08 Sep 2020 21:41:27 GMT

That's exactly right, Kory, Thanks. I think I had it set to auto-scale the contents so it kept trying to cram every record into the table. Once I fixed the size of everything (and did the sort on my field) it sort of sneakily selects the top 20 (or whatever I give it room for). It's actually perfect! And much easier than I was trying to make it. Thanks so much!

Re: Query table for top 10 results

KoryKramer — Wed, 09 Sep 2020 12:34:45 GMT

Awesome. Glad that works!