If I create a join from a standalone table to a feature class, then I want the FC's shape field to be included in the list of joined fields in the attribute table.
I'm aware that I can do something similar with an EGDB query layer or database view via SQL. But it would be best if I could do it in an OOTB join too -- for simplicity, ease of creation, and for parts of the ArcGIS platform that don't support SQL joins.
The resulting Contents item would be a spatial feature layer, not a standalone table view.
I'm aware that we can't bring in the joined shape when joining from an FC to an FC, since that would result in two shape fields in the same attribute table, which would destabilize ArcGIS Pro. See @DrewFlater's comment here.
However, the standalone table to FC scenario is different, because there would only be one shape field in the resulting attribute table.
It should work unless I misunderstood what you asked for 😞
If I have a FC and a table in my database and I want to join them, I'd do this:
It creates the join between the layer and standalone table --> basically brings all attributes from the table to the feature layer.
please let me know if I misunderstood.
@TanuHoque Right. I was thinking standalone table to FC, not FC to standalone table. In ArcMap, FC to standalone table wouldn't have done what I want, since the FC to table relationship is 1:M, and ArcMap doesn't support 1:M joins. But ArcGIS Pro does support 1:M joins, so Pro can do what I want, as you described.
I think you can close this idea.
Just a heads up to anyone reading this:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.