I currently have a large list of feature datasets and dbf tables in a geodatabase. I would like to join each shapefile with its matching DBF file using the "Make Query Table" tool and then "Copy Features" to produce a new shapefile with specified fields.
I am trying to automate this process so I don't have to manually select field names for each set of data (output table would use the same fields). By using the Iterate Datasets in ModelBuilder, I was hoping to do this. However, the Make Query Table will not connect to the geodatabase and still requires me to plug in a specific table. Does anyone know I can use looping to run this process? Are there any similar examples using python?
Example of Geodatabase: AAA1_part1.shp AAA1_part1.dbf AAA2_part2.shp AAA2_part2.shp ..... .....
Any information would be greatly appreciated! Thanks