topic Re: Clipping two layers with matching column headings in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426660#M14359 <HTML><HEAD></HEAD><BODY><SPAN>Original User: JSkinn3</SPAN><BR /><BR /><SPAN>Hi Mike,</SPAN><BR /><BR /><SPAN>You can accomplish this by creating a Join.&nbsp; See the link below for the steps:</SPAN><BR /><BR /><A href="http://resourcesdev.arcgis.com/en/help/main/10.1/index.html#/Joining_attributes_in_one_table_to_another/005s0000002q000000/">http://resourcesdev.arcgis.com/en/help/main/10.1/index.html#/Joining_attributes_in_one_table_to_another/005s0000002q000000/</A><BR /><BR /><SPAN>After the join is created, you can create a new shapefile/feature class by right-clicking on the polygon lakes layer &gt; Data &gt; Export Data.</SPAN></BODY></HTML> Mon, 12 Nov 2012 12:45:57 GMT Anonymous User 2012-11-12T12:45:57Z Clipping two layers with matching column headings https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426659#M14358 <HTML><HEAD></HEAD><BODY><SPAN>Original User: mharr3636</SPAN><BR /><BR /><SPAN>Hello there.&nbsp; I am trying to clip two layers that have the matching column headings for my graduate project.&nbsp; I have a spreadsheet with lake numbers for lakes in Minnesota and a file from the MN DNR Deli that has all of the lake numbers from all of the lakes in the state of MN.&nbsp; Importing my spreadsheet gives me a point feature of my 1506 lakes from my spreadsheet. The file from the DNR has ~49,000 polygons of the lakes in MN.</SPAN><BR /><BR /><SPAN>The two layers lake_types (point) and watr_dnrpy2 (polygon) have the matching column heading DOWLKNUM.&nbsp; The lake_types layer has 1506 records while the watr_dnrpy2 has ~49,000 records.&nbsp; For the final product, I would like to have a layer with the 1506 lakes in polygon format.&nbsp; So in other words, out of the 49,000 records, I would like to match the DOWLKNUM heading and create a new layer with the 1506 lakes in polygon format.&nbsp; If anyone is able to help me with this function it would be much appreciated.&nbsp; I took screenshots of the attribute tables and can be found below.&nbsp; Thanks.</SPAN><BR /><BR /><SPAN>[ATTACH=CONFIG]19210[/ATTACH]</SPAN><BR /><BR /><SPAN>[ATTACH=CONFIG]19211[/ATTACH]</SPAN></BODY></HTML> Mon, 12 Nov 2012 00:10:14 GMT https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426659#M14358 Anonymous User 2012-11-12T00:10:14Z Re: Clipping two layers with matching column headings https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426660#M14359 <HTML><HEAD></HEAD><BODY><SPAN>Original User: JSkinn3</SPAN><BR /><BR /><SPAN>Hi Mike,</SPAN><BR /><BR /><SPAN>You can accomplish this by creating a Join.&nbsp; See the link below for the steps:</SPAN><BR /><BR /><A href="http://resourcesdev.arcgis.com/en/help/main/10.1/index.html#/Joining_attributes_in_one_table_to_another/005s0000002q000000/">http://resourcesdev.arcgis.com/en/help/main/10.1/index.html#/Joining_attributes_in_one_table_to_another/005s0000002q000000/</A><BR /><BR /><SPAN>After the join is created, you can create a new shapefile/feature class by right-clicking on the polygon lakes layer &gt; Data &gt; Export Data.</SPAN></BODY></HTML> Mon, 12 Nov 2012 12:45:57 GMT https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426660#M14359 Anonymous User 2012-11-12T12:45:57Z Re: Clipping two layers with matching column headings https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426661#M14360 <HTML><HEAD></HEAD><BODY><SPAN>Original User: mharr3636</SPAN><BR /><BR /><SPAN>That link doesn't seem to be working.</SPAN></BODY></HTML> Mon, 12 Nov 2012 23:44:21 GMT https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426661#M14360 Anonymous User 2012-11-12T23:44:21Z Re: Clipping two layers with matching column headings https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426662#M14361 <HTML><HEAD></HEAD><BODY><SPAN>Try the following link </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#/Joining_attributes_in_one_table_to_another/005s0000002q000000/">here</A><SPAN>.</SPAN></BODY></HTML> Tue, 13 Nov 2012 09:26:05 GMT https://community.esri.com/t5/geoprocessing-questions/clipping-two-layers-with-matching-column-headings/m-p/426662#M14361 JakeSkinner 2012-11-13T09:26:05Z