topic Re: Retrieving data From one table to another table in Mapping Questions https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330068#M3516 <HTML><HEAD></HEAD><BODY><SPAN>What about the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000050000000">Append</A><SPAN> tool under Data Management &gt; General &gt; Append?&nbsp; You can use the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000006v000000">Make Table View</A><SPAN> tool to use SQL Expressions to append the records that you need.</SPAN></BODY></HTML> Thu, 31 Jan 2013 15:49:33 GMT JonathanQuinn 2013-01-31T15:49:33Z Retrieving data From one table to another table https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330067#M3515 <HTML><HEAD></HEAD><BODY><SPAN>Hopefully someone could help me. Watch the video below it explains my problem and you can actually see what i am talking about.</SPAN><BR /><SPAN>I write the problem. I have two attribute tables and they have a field in common. I am trying to do automation either by python or field calculator to get information from one table to another one. I could do it manually but that would take me time which i dont have a lot of time.</SPAN><BR /><SPAN>I also have lync so i can seen you an invite for you can see my screen you dont need to have the software just an internet connection.</SPAN><BR /><SPAN>My email is </SPAN><A href="mailto:hchapa@lrgvdc911.org">hchapa@lrgvdc911.org</A><SPAN> and my number is 956-682-3481 ext. 143.</SPAN><BR /><BR /><SPAN>My name is hector.</SPAN><BR /><BR /><SPAN>See the video the link i provide below it will explain and you can actually see the problem thanks.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><VIDEO src="https://www.youtube.com/watch?v=ydBS0zYsIYs"></VIDEO></BODY></HTML> Thu, 31 Jan 2013 15:05:18 GMT https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330067#M3515 HectorChapa 2013-01-31T15:05:18Z Re: Retrieving data From one table to another table https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330068#M3516 <HTML><HEAD></HEAD><BODY><SPAN>What about the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000050000000">Append</A><SPAN> tool under Data Management &gt; General &gt; Append?&nbsp; You can use the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000006v000000">Make Table View</A><SPAN> tool to use SQL Expressions to append the records that you need.</SPAN></BODY></HTML> Thu, 31 Jan 2013 15:49:33 GMT https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330068#M3516 JonathanQuinn 2013-01-31T15:49:33Z Re: Retrieving data From one table to another table https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330069#M3517 <HTML><HEAD></HEAD><BODY><SPAN>I don't want to append they are not the same file one is polygon the other is a point could you watch the video. They have a unique value i just trying to obtain the data from one table and transfer over to the other table.</SPAN></BODY></HTML> Thu, 31 Jan 2013 18:55:52 GMT https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330069#M3517 HectorChapa 2013-01-31T18:55:52Z Re: Retrieving data From one table to another table https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330070#M3518 <HTML><HEAD></HEAD><BODY><SPAN>Nice idea to create a video.&nbsp; </SPAN><BR /><BR /><SPAN>Have you considered using a point in polygon overlay tool like intersect?&nbsp; This would allow you to tranfer your attributes.&nbsp; You may get more stuff than you need but you can always delete the duplicate fields.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Fri, 01 Feb 2013 12:39:23 GMT https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330070#M3518 JeffBarrette 2013-02-01T12:39:23Z Re: Retrieving data From one table to another table https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330071#M3519 <HTML><HEAD></HEAD><BODY><SPAN>You can also do a spatial join which will give the points all the attributes of the polygon they're inside.</SPAN></BODY></HTML> Tue, 05 Feb 2013 20:50:57 GMT https://community.esri.com/t5/mapping-questions/retrieving-data-from-one-table-to-another-table/m-p/330071#M3519 TrishRice 2013-02-05T20:50:57Z