https://community.esri.com/t5/arcgis-pro-questions/joining-multiple-categories-for-polygons/m-p/1695177#M102710 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/985066">@IsaacFuller</a>,</P><P>In pro, there is an option where you have the ability to join either as a one to one or as a one to many such that, if there are multiple records with the same field, then you can join the larger of the datasets with the smaller one and a single joined record will be created for every duplicate row with that exact id.</P><P>If it is a true one to one but the polygons have some manner of overlap then a spatial join might be best.</P><P>You can also use the <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/big-data-analytics/join-features.htm" target="_blank" rel="noopener">join features</A> tool to join the two datasets.</P> Wed, 08 Apr 2026 19:48:46 GMT RPGIS 2026-04-08T19:48:46Z https://community.esri.com/t5/arcgis-pro-questions/joining-multiple-categories-for-polygons/m-p/1695089#M102699 <P>Hello all,</P><P>I am currently trying to map some Census data onto Lower Super Output Areas. The Census data has the code of the LSOA (which I will be using for the join), 11 categories for the specific dataset per LSOA, and the observed count. I am trying to display each categories observation count, however cannot figure out how to make the join, as I believe it is a 1:1 situation.&nbsp;</P><P>Any help would be appreciated,</P><P>Thanks</P> Wed, 08 Apr 2026 16:04:51 GMT https://community.esri.com/t5/arcgis-pro-questions/joining-multiple-categories-for-polygons/m-p/1695089#M102699 IsaacFuller 2026-04-08T16:04:51Z https://community.esri.com/t5/arcgis-pro-questions/joining-multiple-categories-for-polygons/m-p/1695177#M102710 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/985066">@IsaacFuller</a>,</P><P>In pro, there is an option where you have the ability to join either as a one to one or as a one to many such that, if there are multiple records with the same field, then you can join the larger of the datasets with the smaller one and a single joined record will be created for every duplicate row with that exact id.</P><P>If it is a true one to one but the polygons have some manner of overlap then a spatial join might be best.</P><P>You can also use the <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/big-data-analytics/join-features.htm" target="_blank" rel="noopener">join features</A> tool to join the two datasets.</P> Wed, 08 Apr 2026 19:48:46 GMT https://community.esri.com/t5/arcgis-pro-questions/joining-multiple-categories-for-polygons/m-p/1695177#M102710 RPGIS 2026-04-08T19:48:46Z