idea Create tabular labels with multiple attribute fields in ArcGIS Pro Ideas

Create tabular labels with multiple attribute fields

MarcBate1 — Mon, 04 Apr 2011 00:35:52 GMT

Please add support for tabular labels that show multiple fields and support row/column totals and formatting similar to those available in Excel 2010.

These should provide the following options when choosing the feature class attribute fields to use for the tables:

Transpose tables (fields across left instead of top)
Calculated fields - expressions using other field attribute values
Formatting similar to those available in Excel for tables including cell shading, borders. Each field used would be assigned a style gallery item so the header cells or total columns could be easily configured. There could be a new Table Labels style class that saves this configuration of all the styles similar to the legend styles. The Table Styles under the Excel 2010 ribbon would be a good thing to follow, where you can easily set the 'Table Style Options' such as Header Row, Banded Rows, Total Row, etc.

Support automatic creation and styling of row and column totals
Allow for what would otherwise be multiple tables with just 1 label per feature to be grouped so if there are multiple dates in the feature class for example, you'll get multiple rows in your table, i.e. define a row grouping field
Support converting these labels to annotation via ArcMap UI as well as a geoprocessing tool to convert the labels to annotation, but that's really another new request

Here's an example markup using Excel 2010 tables that were copied and pasted into Layout view as EMF images and grouped with callout symbols whose text was empty and rectangle is under the tables.

*Each label here would actually be coming from a different feature class, so for each feature class, all the tables would look the same of course.

Re: Create tabular labels with multiple attribute fields

MarcBate1 — Thu, 07 Apr 2011 16:49:56 GMT

This would be a solution for the idea How to show attribute values on the Pie Chart from Symbology

Re: Create tabular labels with multiple attribute fields

CameronWallace — Mon, 02 May 2011 23:15:46 GMT

Alternatively, move the XSL encoding from just in the HTML popup to optionally apply to the label as well (this would make ArcPhoto somewhat obsolete too...)
This would be a huge improvement on the current labelling expressions. (VBScript and Jscript options)

OR Even better add HTML interpretation along with JScript/VBScript so that you can combine...

Re: Create tabular labels with multiple attribute fields

JamalNUMAN — Mon, 13 Jun 2011 00:56:23 GMT

quite essentail. thank you.

Re: Create tabular labels with multiple attribute fields

RogerBannister — Mon, 18 Jul 2011 21:24:24 GMT

This would be fantastic in the environmental consulting industry. Regulators always like to see this kind of labeling and it would be nice if this were built-in functionality. Allowing HTML table tags in labels would be a good start.

Re: Create tabular labels with multiple attribute fields

JasonMeadows — Wed, 03 Aug 2011 17:31:30 GMT

Full HTML implementation would be the way to go! I have internal clients who demand specific table format, from Excel or Word. It would be easy to conver those patterns into html and copy and past it in the label.

I can do a similiar thing with the HTML popups but it has the unattractive window that is unfit for printing. I'd prefer to be able to handle its display characteristics like I do for callout features.

Re: Create tabular labels with multiple attribute fields

BrettElliot2 — Thu, 25 Aug 2011 17:27:43 GMT

This is a great Idea. Much better than importing from word / excel or trying to create via VBScript.

Re: Create tabular labels with multiple attribute fields

AndrewBrown16 — Wed, 21 Sep 2011 20:34:20 GMT

Fantastic idea!

Re: Create tabular labels with multiple attribute fields

KnutTorgerson1 — Fri, 23 Sep 2011 20:09:02 GMT

Been dreaming of this feature since the 3.x days...Please!!

Re: Create tabular labels with multiple attribute fields

JenniferMinnick — Wed, 09 May 2012 16:10:45 GMT

I'd like this especially for formatted tables in the layout view.

It's a pain to format tables in Excel only to bring them in to have the cell coloring disappear.

It's extra work all around.

Re: Create tabular labels with multiple attribute fields

PeterKasianchuk — Tue, 15 May 2012 15:40:59 GMT

A dynamic link to the data would also be useful, rather than having to re-create a static image every time a single value in the table is changed / updated. This is a chronic, time-consuming issue for us, whereby the locations are fixed, but the data changes regularly.

Re: Create tabular labels with multiple attribute fields

JimThomas — Tue, 22 May 2012 21:56:30 GMT

This is a great idea. IThe closest I've been able to get to crosstab tables in ArcGIS is by using an interface created by Earthsoft and EnviroInsite. The results get tabulated and very crude annotation is created and copied into the data frame as text and shapes. If ArcGIS had the functionality to include row/columns in the label, we would be able to get closer to our dream of having a true table as a label. On a related note, I would like the functionality to label based on related tables. EXAMPLE: label one location with mulitple laboratory results (many to one relationship).

Thanks!

Re: Create tabular labels with multiple attribute fields

CameronWallace — Fri, 07 Sep 2012 20:36:47 GMT

This should really be considered in conjuction with this idea: https://c.na9.visual.force.com/apex/ideaView?id=087E00000004Dv8IAE

Anyone come across any decent work-arounds that can be automated? (i.e. please... no more manual excel insertion)

Re: Create tabular labels with multiple attribute fields

CameronWallace — Mon, 03 Jun 2013 18:56:16 GMT

Any activity on this? ESRI?

Re: Create tabular labels with multiple attribute fields

CameronWallace — Mon, 03 Jun 2013 18:56:17 GMT

Any activity on this? ESRI?

Re: Create tabular labels with multiple attribute fields

CameronWallace — Fri, 28 Jun 2013 00:08:29 GMT

Hmmm... might be time to look at the open source options...
http://planet.qgis.org/planet/tag/2.0/

Re: Create tabular labels with multiple attribute fields

AndrewBrown16 — Wed, 31 Jul 2013 14:07:04 GMT

Any updates, ESRI? This is a great idea that should be implemented.

I have an ArcMap plugin that creates tables via Excel Interop and pastes the formatted tables as images into ArcMap, but they're images and don't have a leaderline. If I were to create fully customizable tables with leaderlines, that would be amazing.

Re: Create tabular labels with multiple attribute fields

CameronWallace — Tue, 10 Sep 2013 00:29:40 GMT

Inserting excel tables into my layout just about kills me... some implementation of this is really overdue. Preferably feature linked annotation based on related tables... or html formatting allowed in label expressions or... something that actually allows linework to be drawn between the cells, and formatting of the data, and updates.

Re: Create tabular labels with multiple attribute fields

SolanaFoo2 — Wed, 18 May 2022 13:57:12 GMT

Yes please

Re: Create tabular labels with multiple attribute fields

KevinBrown10 — Wed, 18 May 2022 14:10:15 GMT

This would be super valuable and amazing!