topic relate in model builder in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/relate-in-model-builder/m-p/756148#M2643 <HTML><HEAD></HEAD><BODY><P>I have a one-to-many relationship and would like to iterate through each record in the table, select the records in the related table, query to find if a specific value, then calculate field1 in the iterate table, if another value then calculate field2 in iterate table. &nbsp;I am trying to add the values from a one-to-many relate to the source table so that I can get ride of the relate.&nbsp;</P></BODY></HTML> Mon, 06 Mar 2017 16:13:59 GMT JoanneHalls 2017-03-06T16:13:59Z relate in model builder https://community.esri.com/t5/modelbuilder-questions/relate-in-model-builder/m-p/756148#M2643 <HTML><HEAD></HEAD><BODY><P>I have a one-to-many relationship and would like to iterate through each record in the table, select the records in the related table, query to find if a specific value, then calculate field1 in the iterate table, if another value then calculate field2 in iterate table. &nbsp;I am trying to add the values from a one-to-many relate to the source table so that I can get ride of the relate.&nbsp;</P></BODY></HTML> Mon, 06 Mar 2017 16:13:59 GMT https://community.esri.com/t5/modelbuilder-questions/relate-in-model-builder/m-p/756148#M2643 JoanneHalls 2017-03-06T16:13:59Z Re: relate in model builder https://community.esri.com/t5/modelbuilder-questions/relate-in-model-builder/m-p/756149#M2644 <HTML><HEAD></HEAD><BODY><P>A common approach to convert a one to many to relate to one to one is to summarize the related table by the key. The Summary Statistics tool can give you a table unique by your key, which you can then join up one-to-one.</P><P></P><P>Another approach to consider would be to take your "many" table and join back to the source ("many to one"), you could then use a arcpy.da.SearchCursor in a little function embedded in the Calculate Value tool to do your work.</P><P></P><P>I hope this is some help.</P></BODY></HTML> Wed, 08 Mar 2017 04:51:41 GMT https://community.esri.com/t5/modelbuilder-questions/relate-in-model-builder/m-p/756149#M2644 curtvprice 2017-03-08T04:51:41Z