topic arcpy.TableCompare_management - Limit to 1 record in Python Questions https://community.esri.com/t5/python-questions/arcpy-tablecompare-management-limit-to-1-record/m-p/197439#M15127 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am creating a script that involves the following step: Check the first and last record to make sure they match. I am using the arcpy.TableCompare_management tool. This is my script, so far...</SPAN><BR /><BR /><PRE class="plain" name="code"> &gt;&gt;&gt; #Step 5 (Part 2): Compare record attributes ... currentTable = r"C:\BGale\OwnershipScriptTool\OwnershipScriptTool.gdb\ParcelOwnership" ... newTable = r"C:\BGale\OwnershipScriptTool\OwnershipScriptTool.gdb\ParcelOwnership_NEW" ... arcpy.TableCompare_management(currentTable, newTable, "OBJECTID", "ATTRIBUTES_ONLY", "", "", "map_apn", "", r"C:\BGale\OwnershipScriptTool\OwnershipTableCompare.txt") ... </PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>I omit the field "map_apn" because it is included in the newTable but not the currentTable. </SPAN><BR /><BR /><SPAN>QUESTION: How do I limit the comparison to just the first and last record? Or just one record?</SPAN><BR /><BR /><SPAN>Also, how would I limit the fields to just 1 field? I see the omit option, but I don't want to omit 88/90 fields. It seems that I should be able to specify the fields I DO want instead of only the fields I DO NOT want. </SPAN><BR /><BR /><SPAN>Thank you in advance!</SPAN></BODY></HTML> Tue, 21 Feb 2012 19:20:49 GMT BrittanyGale 2012-02-21T19:20:49Z arcpy.TableCompare_management - Limit to 1 record https://community.esri.com/t5/python-questions/arcpy-tablecompare-management-limit-to-1-record/m-p/197439#M15127 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am creating a script that involves the following step: Check the first and last record to make sure they match. I am using the arcpy.TableCompare_management tool. This is my script, so far...</SPAN><BR /><BR /><PRE class="plain" name="code"> &gt;&gt;&gt; #Step 5 (Part 2): Compare record attributes ... currentTable = r"C:\BGale\OwnershipScriptTool\OwnershipScriptTool.gdb\ParcelOwnership" ... newTable = r"C:\BGale\OwnershipScriptTool\OwnershipScriptTool.gdb\ParcelOwnership_NEW" ... arcpy.TableCompare_management(currentTable, newTable, "OBJECTID", "ATTRIBUTES_ONLY", "", "", "map_apn", "", r"C:\BGale\OwnershipScriptTool\OwnershipTableCompare.txt") ... </PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>I omit the field "map_apn" because it is included in the newTable but not the currentTable. </SPAN><BR /><BR /><SPAN>QUESTION: How do I limit the comparison to just the first and last record? Or just one record?</SPAN><BR /><BR /><SPAN>Also, how would I limit the fields to just 1 field? I see the omit option, but I don't want to omit 88/90 fields. It seems that I should be able to specify the fields I DO want instead of only the fields I DO NOT want. </SPAN><BR /><BR /><SPAN>Thank you in advance!</SPAN></BODY></HTML> Tue, 21 Feb 2012 19:20:49 GMT https://community.esri.com/t5/python-questions/arcpy-tablecompare-management-limit-to-1-record/m-p/197439#M15127 BrittanyGale 2012-02-21T19:20:49Z