topic Re: Is it available to join table with feature layer depending on two fields? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/is-it-available-to-join-table-with-feature-layer/m-p/739555#M32441 <HTML><HEAD></HEAD><BODY><P>Short answer, no.&nbsp; The answer hasn't really changed from <A href="https://community.esri.com/thread/7223">Joining based on multiple fields</A>.</P><P></P><P>Multi-field joins are not supported in most ArcGIS geoprocessing tools.&nbsp; For example, <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; uses a "common attribute field", not fields.&nbsp; The best approach would be to create a compound-key field based on your multiple fields.&nbsp; You can try to be creative with <A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-table.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-table.htm">Make Query Table—Data Management toolbox | Documentation</A>, but there are lots of limitations and caveats going down that path too.</P></BODY></HTML> Sat, 04 Apr 2020 14:43:12 GMT JoshuaBixby 2020-04-04T14:43:12Z Is it available to join table with feature layer depending on two fields? https://community.esri.com/t5/arcgis-pro-questions/is-it-available-to-join-table-with-feature-layer/m-p/739554#M32440 <HTML><HEAD></HEAD><BODY><P>Is it available to join table with feature layer depending on two fields?</P><P></P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/487410_Join.png" /></P></BODY></HTML> Sat, 04 Apr 2020 13:08:50 GMT https://community.esri.com/t5/arcgis-pro-questions/is-it-available-to-join-table-with-feature-layer/m-p/739554#M32440 abdullahqasrawi 2020-04-04T13:08:50Z Re: Is it available to join table with feature layer depending on two fields? https://community.esri.com/t5/arcgis-pro-questions/is-it-available-to-join-table-with-feature-layer/m-p/739555#M32441 <HTML><HEAD></HEAD><BODY><P>Short answer, no.&nbsp; The answer hasn't really changed from <A href="https://community.esri.com/thread/7223">Joining based on multiple fields</A>.</P><P></P><P>Multi-field joins are not supported in most ArcGIS geoprocessing tools.&nbsp; For example, <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; uses a "common attribute field", not fields.&nbsp; The best approach would be to create a compound-key field based on your multiple fields.&nbsp; You can try to be creative with <A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-table.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-table.htm">Make Query Table—Data Management toolbox | Documentation</A>, but there are lots of limitations and caveats going down that path too.</P></BODY></HTML> Sat, 04 Apr 2020 14:43:12 GMT https://community.esri.com/t5/arcgis-pro-questions/is-it-available-to-join-table-with-feature-layer/m-p/739555#M32441 JoshuaBixby 2020-04-04T14:43:12Z