Is it possible for a Related Table to be Symbolized?

AyokunleAdebisi1

Hello, I have a feature attribute table (82) which i related as 1:M relationship to an excel sheet(74,000). The reason for the relationship is because when i joined, i have over 3,000k information missing. But when i relate the tables no issues, so now I am trying to symbolise the the quantity field which is in the excel sheet  on the feature polygon but it is proving difficult as the symbology field does not show the quantity field from the excel sheet that will be symbolized on the shapefile. What could be the solution to this? is it possible at all to symbolize a related database where the field that will be symbolize is in the excel sheet not the feature attribute table? Thank you for your quick response.

XanderBakker

Hi Ayokunle Adebisi ,

You mention that you have a quantity field in the related table that you want to visualize. Your cardinality is 1:m. Do you want to visualize every individual quantity value for each feature? That will be difficult, because the features will overlap. You can join the related information to the features and when you switch off the option "Keep All Target Features" the features will duplicate and produce a feature for each related record:

Normally, you will want to run some statistics to visualize the average, max or min value or perhaps the most recent. This can be done using for instance Arcade, however it will need to be done in a field calculation, since the symbology profile does not allow you to access the related table.