topic Join Data in Model Builder in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/join-data-in-model-builder/m-p/210152#M7159 <HTML><HEAD></HEAD><BODY><P>I am trying to add the exact same process used when you right click and join a polygon to point layer. I want that same dialog box for parameters. Is that even possible? When I try Add Join or Spatial Join, it doesn't give me the ability to choose the same options as Join Data does....</P><P>Basically I am taking a polygon layer and joining it to a point layer, where each polygon will be given a summary of the attributes &nbsp;of points that fall inside it, using either SUM or AVG to summarize the data.&nbsp;</P></BODY></HTML> Thu, 08 Jun 2017 15:07:22 GMT ShannonPankow1 2017-06-08T15:07:22Z Join Data in Model Builder https://community.esri.com/t5/geoprocessing-questions/join-data-in-model-builder/m-p/210152#M7159 <HTML><HEAD></HEAD><BODY><P>I am trying to add the exact same process used when you right click and join a polygon to point layer. I want that same dialog box for parameters. Is that even possible? When I try Add Join or Spatial Join, it doesn't give me the ability to choose the same options as Join Data does....</P><P>Basically I am taking a polygon layer and joining it to a point layer, where each polygon will be given a summary of the attributes &nbsp;of points that fall inside it, using either SUM or AVG to summarize the data.&nbsp;</P></BODY></HTML> Thu, 08 Jun 2017 15:07:22 GMT https://community.esri.com/t5/geoprocessing-questions/join-data-in-model-builder/m-p/210152#M7159 ShannonPankow1 2017-06-08T15:07:22Z Re: Join Data in Model Builder https://community.esri.com/t5/geoprocessing-questions/join-data-in-model-builder/m-p/210153#M7160 <HTML><HEAD></HEAD><BODY><P>Shannon,</P><P></P><P>Have you tried <A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/analyze/executing-tools/using-the-field-mapping-control.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/analyze/executing-tools/using-the-field-mapping-control.htm">Using the field mapping control—Help | ArcGIS for Desktop</A>&nbsp;</P><P></P><P>I believe adding a Integer (Short or Long) or Double field will allow you to calculate SUM, AVG to summarize the data.</P><P></P><P>I hope this helps!</P><P></P><P>~Shan</P></BODY></HTML> Wed, 28 Jun 2017 09:37:18 GMT https://community.esri.com/t5/geoprocessing-questions/join-data-in-model-builder/m-p/210153#M7160 shan_sarkar 2017-06-28T09:37:18Z