topic Points Attribute Compare in Spatial Data Science Questions https://community.esri.com/t5/spatial-data-science-questions/points-attribute-compare/m-p/274634#M631 <HTML><HEAD></HEAD><BODY><P>I have two shapefiles, my current addresses shp and a source's updated addresses shp for the same coverage area. I have a key that links the two record to record. I'm new to python, and I'm generating a script that will allow me to input the two tables, join them based on key, and output a third table that displays the differences. Differences records would be appended to the new table after running through a series of checks: ie. does table 1 [Addressno] = table 2 [AddresVal], if not, append entire record to new differences table and indicate which fields do not match. Also looking to have it indicate if a source record is found in Table 2 (updated incoming data), but not Table 1 (my current data).&nbsp;</P><P></P><P>I do not think this is a novel process. Can anyone share their scripts/ideas with me on how to accomplish this? I'm trying to develop it as a tool to run within arc.</P><P></P><P>Thank you all!</P></BODY></HTML> Thu, 17 Sep 2020 22:33:48 GMT LaurenDiGiovanni1 2020-09-17T22:33:48Z Points Attribute Compare https://community.esri.com/t5/spatial-data-science-questions/points-attribute-compare/m-p/274634#M631 <HTML><HEAD></HEAD><BODY><P>I have two shapefiles, my current addresses shp and a source's updated addresses shp for the same coverage area. I have a key that links the two record to record. I'm new to python, and I'm generating a script that will allow me to input the two tables, join them based on key, and output a third table that displays the differences. Differences records would be appended to the new table after running through a series of checks: ie. does table 1 [Addressno] = table 2 [AddresVal], if not, append entire record to new differences table and indicate which fields do not match. Also looking to have it indicate if a source record is found in Table 2 (updated incoming data), but not Table 1 (my current data).&nbsp;</P><P></P><P>I do not think this is a novel process. Can anyone share their scripts/ideas with me on how to accomplish this? I'm trying to develop it as a tool to run within arc.</P><P></P><P>Thank you all!</P></BODY></HTML> Thu, 17 Sep 2020 22:33:48 GMT https://community.esri.com/t5/spatial-data-science-questions/points-attribute-compare/m-p/274634#M631 LaurenDiGiovanni1 2020-09-17T22:33:48Z