Hello Everyone,
I am creating a model builder that simply takes a Town Polygon layer and joins it to a standalone table. After the table is joined to the layer the feature will be exported and then published to AGOL. Quite simple (I know), but am having issues when I need to re-run or update the stand alone table. Here is what my current model looks like.
The first time the model run it works fine and the exported feature on AGOL has what I want, but lets say I get new data (Sheet2$) and switch this out for Sheet1$. When run there are no errors in the processing messages, but when I go and open the exported layer the table is full of Null data. Why is this happening?
Note: When first building the model builder I had the polygon layer added directly to the join, but then when I go to do the other join the old data is still present which is why I added the remove join before the add join, so any previous joins on the layer will be removed and the new data will be joined.