ERROR

ERROR 000210: Cannot create output <file path>. Failed to execute (PivotTable)

Last Published: January 14, 2021

Error Message

In ArcGIS Pro, to make data analysis more efficient, the Pivot Table tool can be used to reduce redundancy in records and flatten one-to-many relationships. However in some instances, the tool fails to execute and returns the following error message:

Error:   
ERROR 000210: Cannot create output <file path>. Failed to execute (PivotTable).
Image of the ERROR 000210 error message

Cause

The known causes of the error are described in this article, ArcGIS Pro: 000210: Cannot create output <value>. In this instance, running the Pivot Table tool results in the error because the column in the attribute table selected as the Pivot Field contains null values.

Solution or Workaround

Use one of the following workflows to resolve this issue.

Find and replace null values with zeroes

Use the Find and Replace control in ArcGIS Pro to replace the null values in the attribute table with zeroes. Refer to ArcGIS Pro: Replace values in a table cell for steps to do so.

  1. For Find, type <Null>. This string is case sensitive.
  2. For Replace, type 0.
Image showing the Find and Replace control of an attribute table

Replace null values with zeroes using the ArcPy module or the Calculate Field tool

Refer to How To: Replace null values with zeroes in an attribute table in ArcGIS Pro for workflows on replacing the null values with zeroes using either the ArcPy module or the Calculate Field tool. To replace the null values with zeroes using the Calculate Field tool, use the conditional operator in the Python parser, or the Reclassify function if 3D Analyst is licensed.

After following either of the workflows above, the Pivot Table tool must be closed and reopened to refresh the data.

Article ID:000024928

Software:
  • ArcGIS Pro 2 7 x
  • ArcGIS Pro 2 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic