2

I have created a model that utilises the Pivot Table tool. When I run the model, the tool creates a DBF file in a file GDB. However the naming convention of the file is incorrect. It just has the name "dbf", rather than the output table name stated in the parameters. It subsequently stops the model from continuing giving me an error:

ERROR 000229: Cannot open C:\AIS\Model_testing_area\AIS_2013_Density.gdb\PivotTable.dbf Failed to execute (Add Join). I have tried to trim the name, change the workspaces (in_memory, %currentworkspace%) however to no avail.

Model

Pivot Table Parameters

GDB file

PolyGeo ♦
65.5k29 gold badges115 silver badges350 bronze badges
asked Apr 12, 2016 at 11:08
1
  • 3
    You cannot have a file extension ".dbf" within a geodatabase. Try removing the extension part and re-run the model. Commented Apr 12, 2016 at 11:22

1 Answer 1

4

You cannot save a table in a geodatabase with an extension like ".dbf". Remove the extension and the tool should run.

answered Apr 12, 2016 at 11:29
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.