The operation I want to perform is the Add join in ArcMap 10.0. It works perfectly when done with one file but I need to do it with a few hundreds tables.
What I have is ONE shapefile with divisions, and multiple tables for different years/species. For each table I want to add join to the shapefile and save the result.
I am trying to use model builder and the problem I have is that in the "layer name or table view" input it doesn't let me pick a shapefile unless it's loaded in the workspace. Also when I use the "copy features" to save the result of the add join to disk, it messes up the column names of the new shapefile. I also don't want to use the Join Field because it doesn't have the option Keep All that Add Join has.