topic Select by attribute in Python Questions https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582288#M45644 <HTML><HEAD></HEAD><BODY><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">I have table with drill hole. Drill hole name is repeating for each drillng interval.</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">For example &nbsp;drill&nbsp;hole &nbsp; &nbsp; &nbsp;interval</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;"></P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; And now I want to get rows &nbsp;name drill hole with minimal interval&nbsp;</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp;a1 1</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp;b1 1&nbsp;</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp;c1 &nbsp;2</P></BODY></HTML> Mon, 22 Aug 2016 13:02:26 GMT AlesgerMammedov2 2016-08-22T13:02:26Z Select by attribute https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582288#M45644 <HTML><HEAD></HEAD><BODY><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">I have table with drill hole. Drill hole name is repeating for each drillng interval.</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">For example &nbsp;drill&nbsp;hole &nbsp; &nbsp; &nbsp;interval</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;"></P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; And now I want to get rows &nbsp;name drill hole with minimal interval&nbsp;</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp;a1 1</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp;b1 1&nbsp;</P><P class="" style="color: #333333; background-color: #cfedfb; border: 0px; font-size: 14px; margin: 0px; padding: 5px 10px;">&nbsp;c1 &nbsp;2</P></BODY></HTML> Mon, 22 Aug 2016 13:02:26 GMT https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582288#M45644 AlesgerMammedov2 2016-08-22T13:02:26Z Re: Select by attribute https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582289#M45645 <HTML><HEAD></HEAD><BODY><P>See reply to your other post:&nbsp;<A href="https://community.esri.com/thread/181767-arcpython-work-with-table">https://community.esri.com/thread/181767-arcpython-work-with-table</A>&nbsp;</P><P>For the sorting part use multiple fields.</P></BODY></HTML> Mon, 22 Aug 2016 13:07:06 GMT https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582289#M45645 FC_Basson 2016-08-22T13:07:06Z Re: Select by attribute https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582290#M45646 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Please check this&nbsp;<BR /><A class="link-titled" href="https://blogs.esri.com/esri/arcgis/2010/08/30/concatenate/" title="https://blogs.esri.com/esri/arcgis/2010/08/30/concatenate/">Concatenating field values using Calculate Field | ArcGIS Blog</A>&nbsp;</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 22 Aug 2016 13:49:20 GMT https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582290#M45646 Anonymous User 2016-08-22T13:49:20Z Re: Select by attribute https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582291#M45647 <HTML><HEAD></HEAD><BODY><P><A class="link-titled" href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Calculate_Field/00170000004m000000/" title="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Calculate_Field/00170000004m000000/">ArcGIS Desktop</A>&nbsp;</P><P></P><P>!Drill_Hole! + str( !Intervel! )</P></BODY></HTML> Mon, 22 Aug 2016 13:50:06 GMT https://community.esri.com/t5/python-questions/select-by-attribute/m-p/582291#M45647 Anonymous User 2016-08-22T13:50:06Z