Community
Select to view content in your preferred language

Join Operation not matching Join Cardinality

162
1
3 weeks ago
PeggyCorey
by
Emerging Contributor
3 weeks ago

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

Preview file
16 KB
Preview file
28 KB
0 Kudos
1 Reply
RPGIS
by MVP Regular Contributor
MVP Regular Contributor
3 weeks ago

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.

0 Kudos