AnsweredAssumed Answered

Issue with joining features with table by multiple columns

Question asked by dljayasekera on Mar 3, 2020
Latest reply on Mar 3, 2020 by bharold-esristaff

I am having an issue with joining polygon feature shape file (A_lines) with a table (Table_1) by multiple columns and not sure which tool to use in ArcGIS 10.4 in the model builder environment. The shape file has 1743000 rows and the table has 11683 rows. The fields I need to join exist in both polygon shape (A_lines) file and table (Table_1). The field names I need to join are (DIV, STATE,POL_NUMBER,CROP,COUNTY). 


Basically, I need to select all the polygons from A_lines shape file that are matching with the fields (DIV, STATE,POL_NUMBER,CROP,COUNTY) in the Table_1.


Can somebody suggest me the correct tool or series of tools to achieve this in ArcGIS 10.4 in model builder environment? 


I tried using the Make a Query Table tool but was not successful in outputting the table or to select the polygons in the A_lines shape file. 


Thank you and appreciate any help.