topic Re: Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many, in ArcGIS Enterprise Questions

Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many,

MajdoleenO_A__Awadallah — Wed, 03 May 2017 08:21:09 GMT

We couldn’t figure out why when we join a feature class with a table, the label/ symbology of the records is appeared only for four records per feature, taking into consideration that the relation between the feature and the table is one to many,

For example, we have a feature class (communities) and a table (All_projects_Area_C_17_4_2017) and want to join the feature with table and keep only the matching records taking into consideration that the relation between the feature and the table is one to many (attached), what we found strange is that the records in the joined table is one by one, but when it comes to label and symbology, the ArcMap 10.5 is displayed the records of the table (more than one record per feature) but if we have for example (1-7 records) only four records (labels/ symbols) appeared per feature. Is this a new behavior when it comes to join? And How to increase the number of displayed records for both labels and symbols (more than four)?

What might be the issue here?

Thank you

Best,

Majdoleen

Re: Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many,

PanGIS — Wed, 03 May 2017 10:00:32 GMT

Hi,

I am afraid you can't use a Join when your cardinality is One to Many

have a look at this: About joining and relating tables—Help | ArcGIS for Desktop

the join works only for One to One, or Many to One.

I would consider the Relate or a Relationship Class

Re: Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many,

MajdoleenO_A__Awadallah — Wed, 03 May 2017 10:15:01 GMT

Hi Pan,

Thank you so much for your reply, I do agree with you, my expectation that the join works only for One to One, but I surprised when we found that the records in the joined table is one by one, but when it comes to label and symbology, the ArcMap 10.5 is displayed the records of the table (more than one record per feature) but if we have for example (1-7 records) only four records (labels/ symbols) appeared per feature.

Please feel free to test it at your environment, kindly download the data from this: File sharing and storage made simple

Best,

Majdoleen

Re: Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many,

MajdoleenO_A__Awadallah — Mon, 03 Jul 2017 10:40:01 GMT

Any updates, Pan gis?

Please feel free to test it at your environment, kindly download the data from this: File sharing and storage made simple

Thank you in advance

Majdoleen

Re: Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many,

PanGIS — Mon, 03 Jul 2017 13:45:19 GMT

Hi Majdoleen,

I got the 4 labels as well at first.

But, if you Open the Labeling toolbar, then enable the Maplex Engine and set the Placement Quality from Fast to Best, you will be able to see the 6 labels.

Try and let me know.

Re: Joining a feature class with a table fails to display the label/ symbology correctly, and only four records per feature is displayed, taking into consideration that the relation between the feature and the table is one to many,

MajdoleenO_A__Awadallah — Tue, 04 Jul 2017 06:23:24 GMT

Great, thank you Pan gis, your solution resolved my issue.

Do you have any idea if we can apply this for symbology too? Right now, the only way to show the symbology of many features is by using offset X and Y.(attached)

But unfortunately, if I have three MDLF projects, it will show only one symbology! What do you think?

If the issue of labeling one to many is resolved by using join, why not to have an option to resolve the symbology of one to many?