Join Field error with Query

157
5
01-25-2021 10:50 AM
HeatherS28
New Contributor II

Similar to BUG-000114646 (Add Join in ArcGIS Pro yields the wrong data when input as view or layer with a query), Join Field is yielding the wrong data when the inputted join table is a layer with a query. Instead of joining from the subset of data in the query, it is joining the first value from the whole table. A temporary workaround is to export the queried layer into a new feature class and re-run the join, but it should be able to join from the queried table directly.

0 Kudos
5 Replies
DanPatterson
MVP Notable Contributor

BUG-000114646: Add Join in ArcGIS Pro yields the wrong data when in.. (esri.com)

Are you using ArcGIS Pro 2.7?


... sort of retired...
HeatherS28
New Contributor II

Yes, I'm using 2.7, but this error is occurring with the Join Field function rather than the Add Join function. 

0 Kudos
DanPatterson
MVP Notable Contributor

You might want to open a case with Tech Support then.


... sort of retired...
0 Kudos
HeatherS28
New Contributor II

Submitted! Just curious if anyone else experienced this issue.

0 Kudos
DanPatterson
MVP Notable Contributor

Your workaround of making a standalone subsample prior to the join would have been my preference to begin with.  It compartmentalizes steps so they can be easily replicated.


... sort of retired...
0 Kudos