One to Many Joins Export One to One in Model Builder when Using in_memory

06-18-2021 12:32 PM
Labels (2)
New Contributor III

In model builder, I have a table that when joined to a point feature would have a one-to-many relationship. When using a feature layer in a FGDB and a table in a FGDB, exporting a join between the two results in the one-to-many relationship, meaning more points are exported than existed in the initial point layer. When using in_memory for either the table or the feature layer, the one-to-many relationship is not maintained, and only a single point is exported from the join. 

Any ideas? Is this expected behavior and a limit of the in_memory workspace? 

0 Kudos
0 Replies