https://community.esri.com/t5/arcmap-questions/one-to-many-joins-export-one-to-one-in-model/m-p/1069967#M2642 <P>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.&nbsp;</P><P>Any ideas? Is this expected behavior and a limit of the in_memory workspace?&nbsp;</P> Fri, 18 Jun 2021 19:32:50 GMT LancasterGIS 2021-06-18T19:32:50Z https://community.esri.com/t5/arcmap-questions/one-to-many-joins-export-one-to-one-in-model/m-p/1069967#M2642 <P>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.&nbsp;</P><P>Any ideas? Is this expected behavior and a limit of the in_memory workspace?&nbsp;</P> Fri, 18 Jun 2021 19:32:50 GMT https://community.esri.com/t5/arcmap-questions/one-to-many-joins-export-one-to-one-in-model/m-p/1069967#M2642 LancasterGIS 2021-06-18T19:32:50Z