Join Operation not matching Join Cardinality

PeggyCorey

My 'Join Operation' in ArcGIS Pro 3.3.2 is not matching the resulting 'Join Cardinality' shown in Layer Properties.  Is anyone else experiencing this?  This is ultimately resulting in wrong query results once published as a service.

Thanks for any input!

Peggy

join_card.PNG

join_oper.PNG

abureaux_7-1740501499671.png

abureaux_6-1740501486892.png

RPGIS

Hi @PeggyCorey ,

Typically the issue with joins usually boils down to one of several things:

1. Data types - if one field has datatype different from another field then sometimes that can cause issues
2. Arbitrary values - if the fields are the same datatype but there is some arbitrary value in one of the attributes then that can also cause issues.
3. Depending on what you are publishing, hosted vs sde feature service, then it may boil down to compatibility or some other issue.

I don't know much about publishing joins simply because that is data dependent so I steer away from those.