Select to view content in your preferred language

Pivot Table turns nulls into 0

2541
10
03-27-2018 12:22 PM
by Anonymous User
Not applicable

Is it possible to "tell" the Pivot Table to preserver null values. It is turning them into 0's.

Thank you,

Randy McGregor

0 Kudos
10 Replies
by Anonymous User
Not applicable

This is, apparently, a bug or at least a deficiency in the tool.

NIM101212: The Pivot Table geoprocessing tool displays zeros (0) instead of 'Null' in the output table for no data values even after exporting the table to a geodatabase table or a stand alone database table.

An enhancement has been requested. I've made a python script tool to find cells that should have false zeros and set them to null.

Thanks to all who participated in this discussion.

Randy