Model Builder Error (Joining tables and adding fields)

Discussion created by katze01 on Nov 30, 2011
Latest reply on Dec 1, 2011 by katze01

I am using ArcView 9.3 Modelbuilder.

My problem is the following:

I want to join two dbase tables, make the join permanent and add a field to the new permanent table.

Since I don't have the Join Field Tool, I have to use Add Join which only can join a Table view and a permanent table.

The workflow:

I use "Make Table View" for the first dbase table, then I connect the Table view and the second dBase table to the "Add Join Tool". Afterwards, I use the "Copy Rows" tool to make the connection of the tables permanent. Then I use the "Add Field" Tool.

I get the following error when connecting the new permanent dbase (output of "Copy Rows") to the "Add Field" tool:

"Error 000840". Something with invalid input values.

Funnily, when I first run the model without the Add Field tool; validate the model and run it again with the add field tool, the error does not appear.

I will add a graphic of the model as soon as possible.

Any suggestions are greatly appreciated.

Thank you!