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

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).

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.

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.