topic Re: I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. in Data Management Questions https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523427#M29752 <HTML><HEAD></HEAD><BODY><P>Do you want to Join the tables?</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/join-field.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/join-field.htm">Join Field—Data Management toolbox | Documentation</A>&nbsp;</P></BODY></HTML> Fri, 14 Feb 2020 15:46:28 GMT DanPatterson_Retired 2020-02-14T15:46:28Z I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523426#M29751 <HTML><HEAD></HEAD><BODY><P>This is a basic thing I should know how to do, but I am a bit rusty. I want to select some polygons in a table by many unique values. I have a .xls table with the values I need to pull. and a matching attribute field in my feature layer table. What is the best way to select these polygons from my feature table?</P></BODY></HTML> Fri, 14 Feb 2020 15:43:01 GMT https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523426#M29751 JamesBushOpelika 2020-02-14T15:43:01Z Re: I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523427#M29752 <HTML><HEAD></HEAD><BODY><P>Do you want to Join the tables?</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/join-field.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/join-field.htm">Join Field—Data Management toolbox | Documentation</A>&nbsp;</P></BODY></HTML> Fri, 14 Feb 2020 15:46:28 GMT https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523427#M29752 DanPatterson_Retired 2020-02-14T15:46:28Z Re: I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523428#M29753 <HTML><HEAD></HEAD><BODY><P>As Dan suggests, a table join would achieve this. You could also use a search cursor to append matching values to an empty list and then use select by attribute on the FL.</P><P></P><P>E.g. object_id_list = [1,2,3]</P><P>query = "OBJECTID in (1,2,3)"</P><P>Selectbyattribute(...</P></BODY></HTML> Fri, 14 Feb 2020 15:56:38 GMT https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523428#M29753 DavidPike 2020-02-14T15:56:38Z Re: I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523429#M29754 <HTML><HEAD></HEAD><BODY><P>I don't believe so? I do not want to add anything to my feature layer. I just want to select multiple fields from the feature table based on another spreadsheet.&nbsp;</P></BODY></HTML> Fri, 14 Feb 2020 15:57:09 GMT https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523429#M29754 JamesBushOpelika 2020-02-14T15:57:09Z Re: I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523430#M29755 <HTML><HEAD></HEAD><BODY><P>If you want to select one with the other, then they need to be joined.... the features aren't relevant, the tables are.&nbsp; The are other "join" tools in the help topics that do similar things but the end result is the same... joined tables</P></BODY></HTML> Fri, 14 Feb 2020 16:00:44 GMT https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523430#M29755 DanPatterson_Retired 2020-02-14T16:00:44Z Re: I need some help figuring out the best process to go about selecting multiple unique values from a feature layer table. https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523431#M29756 <HTML><HEAD></HEAD><BODY><P>This worked fine! Thanks, guys!&nbsp; A bit out of touch&nbsp;on the basics this Friday morning. . . . .&nbsp;</P><P></P><P>Cheers!</P></BODY></HTML> Fri, 14 Feb 2020 16:15:15 GMT https://community.esri.com/t5/data-management-questions/i-need-some-help-figuring-out-the-best-process-to/m-p/523431#M29756 JamesBushOpelika 2020-02-14T16:15:15Z