Pro Map Series dynamic tables

[AndrewHargreaves1]

ArcGIS Pro‌ team 

I have a map series that contains a table showing attributes. I use the query funtionality to limit the entries in the table to only those features currently displayed in the map. The limiting attribute is which "district" the feature falls into.

What I really need is to use a related table, as I have features that may be in multiple districts and so to establish a many-to-one relationship. The issue is that then straight tables (as opposed to feature attribute tables) can't be limited by the query function. They just show everything. Is there any other way to achieve this?

[TomBole]

Hi Andrew, 

I'm assuming that the source of your tables are "standalone" tables in the map since the Query option in the Format Table Frame pane is disabled. This happens when the table source is not spatial - like a standalone table.  You can still set a query on the standalone table so that it works with a map series.  You do this using Page query—Layouts | Documentation . 

For example I have a map with a US states layer that drives a map series.  Each page is named by the field value for STATE_NAME. I also have a standalone table of cities and it also has a field STATE_NAME. I can set a Page Query on the cities table so that it only shows feature that match the current page.

Here is a screenshot showing the page for Montana.

I think this might be what you're looking for.  Hope it helps.

Tom

[Marc_Graham]

Hi Tom,

Is it possible to hide the table column headings?

Thanks,

Marc

[Marc_Graham]

Sorry, Just saw this: https://community.esri.com/thread/243394-how-to-remove-field-headings-in-table-frame 

[Aaron]

Andrew:

I have yet to get this to work with a stand-alone table. Page query is set up, but it always displays all records. I am obviously missing something simple... thanks.

[Aaron]

Just a follow up, turns out an older version of Pro (2.6.1) works. Version 2.7 broke something. smh...

[JessicaBennett]

Hi Tom,

Is it possible to do this with a related table? 1 feature to many table records?

Thanks,

Jessica

[TomBole]

Hi Jessica,

You will not be able to use related tables in Table Frame or Map Series scenarios.

Tom

[JenMar_]

Hello,

How did you achieve turning off specific fields in your dynamic table? I have a stand alone table (I applied the Map Series Page Filter as indicated by @TomBole ). I would like to keep the highlighted field in the attached image example.

[TomBole]

Hi JenMar, 

You can turn off specified table frame fields by clicking the checkbox next to the field in the Contents view. Unchecking the box will "turn off" the field. You could also remove the field entirely using the Delete command on the table frame field context menu (select the field and right-click to bring up the menu).

For more information on how to work with the table frame please see Add and modify table frames. There is also a tutorial Work with a table frame.

Hope this helps, 

Tom