There should be an option to create a one-to-many join within Pro, as joins are currently limited to a one-to-one relationship.
Example: A single geometry with many rows in a table. I'd like to have the ability to join the geometry and keep ALL rows from the joined table, not just one.
Check out the answer I have in this post: FGDB: Propagate duplicate features via 1:M join to related table
The docs seem to suggest that’s already possible, under specific circumstances.
Add Join will not create a 1:M join
@mpboyle I think ArcGIS Pro 3.0.3 already does what you want. Adding a join can create a 1:M join.
Make sure both FCs/tables have ObjectIDs and are in the same geodatabase.
I agree with @Bud on this one - this has been possible since the early days of Pro (if not 1.0). He's already pointed to https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm
@mpboyle have you been able to get the result you need? You may need to be working in a geodatabase and not shapefiles - maybe @JonathanNeal can offer additional details if needed but it seems like it is possible to do what you're requesting.
@mpboyle (Or others with similar interests):
If you wish to rework the initial idea a little, there could be future plans to support one-to-many joins between Esri datatypes (.sde, feature services and .gdb) even if the input and join table are not in the same workspace.
This is not in the short term. But, a support investigation has interest here is ENH-000151081.
Our Feature Service team is/may be looking into supporting one-to-many joins using feature service layers. Unsure their status, timeline or technical challenges. But, if they can do it natural follow-up will be for other Esri datatypes to support one-to-many joins.
If you think our documentation can be improved, at the bottom of the help there is a link to click, that I do read: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm
Summary of the doc:
Add Join does support one-to-many when the following two conditions are met:
Details on why:
The internal tool IRelQueryTable has two modes for Joining data together:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.