ERROR 000732 IN ModelBuilder Add Join

[Iron_Mark]

Hi,

I am building a model with modelbuilder and both the ADD JOIN and JOIN FIELD geoprocessing tools are failing with:

ERROR 000732: Input Layer or Table View: xxxx.shp does not exist or is not supported

This error comes for both the shapefile and the csv that I am trying to join.

This seems not to happen when I select the Input table and join table directly from the project.

I need to automate shapefiles and table that are not loaded in the project.

Any idea how to solve this?

Many thanks

[DanPatterson · Accepted solution]

did you validate the join in the model?  apparently it can't be found.

Setting paths to data in Python—ArcGIS Pro | Documentation

perhaps showing your validated model and specifying how, and where, you are running it would help

It could be this bug

BUG-000133896 for ArcGIS Pro (esri.com) which was fixed or one of the other 3

Esri Support Search Results

[Iron_Mark]

Thanks for your help both.

Dan, I think that is probably the bug that you linked, I used join field and it has worked without validating the join.

As a bonus question, do you know how can I do to make the model accept data from a folder that has different names? 

I need the model to pick the shapefile from a specific folder and the name of the shapefile could be different. I don't want to rename the shp everytime

[DanPatterson]

I don't use model builder much any more, but I suspect that you will have to make the folder a model parameter

[MapGrrl]

The Input to these tools is a Layer or Table View. In a Model, use Make Feature Layer to convert the input Feature Class (shapefile) to a Layer FIRST, then use the output Layer as the Input to the join.

It "works" in the Project because the Feature class has been added to the map as a Layer.