I need to join a table to a feature class in a model. Have it keep only the matching records and then export that joined feature class into a new feature class.
1 Answer
Joins are done in modelbuilder to layers, not feature classes, if you are executing from catalog you must make a feature layer first with make feature layer; if you are executing from ArcMap the input should already be a layer. You then join using Add Join, leave the keep all target features unchecked to just keep the joined features. Then to export I use copy features which exports to a feature class with all the joined fields. The whole thing looks like this:
add join dialog here:
Substitute your own layers and field names... That should do it for you.