Joining multiple categories for polygons

[IsaacFuller]

Hello all,

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. 

Any help would be appreciated,

Thanks

[RPGIS]

Hi @IsaacFuller,

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.

If it is a true one to one but the polygons have some manner of overlap then a spatial join might be best.

You can also use the join features tool to join the two datasets.