Join Operation not matching Join Cardinality

PeggyCorey — Thu, 24 Apr 2025 20:53:35 GMT

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

Re: Join Operation not matching Join Cardinality

RPGIS — Fri, 25 Apr 2025 12:55:42 GMT

Hi @PeggyCorey ,

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

Data types - if one field has datatype different from another field then sometimes that can cause issues
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.
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.

topic Re: Join Operation not matching Join Cardinality in ArcGIS Pro Questions

Join Operation not matching Join Cardinality

Re: Join Operation not matching Join Cardinality