Select to view content in your preferred language

Export FC to new FC with Default Field Values and Null Fields - It's doing what??

752
1
07-14-2023 12:01 PM
Labels (2)
Todd_Plank
Occasional Contributor
Is this how Export FC or FC2FC supposed to work?  Very concerning
 
The issue that I ran into is when exporting features from a geodatabase where a field has a default value set and has records that are NULL. What I am seeing is that any records that are NULL will be populated with the Default field value when exported to another geodatabase with ArcPro. I did the same test in ArcMap and NULL values were not populated.
 
Example: Here is a manhole with a field [test] where all the records are NULL
Todd_Plank_0-1689361050194.jpeg

 

In Fields View I set the Default to 123
Todd_Plank_1-1689361076091.jpeg

 

Exporting the feature layer to another feature layer populates that Default value in all the records that are NULL
Todd_Plank_2-1689361099408.jpeg
There is no warning that the records with NULL values will be changing.
 
We ran into this problem while receiving a geodatabase from another source where Default values were set in the records and we exported from those feature layers, thus getting different attribute results in our queries.
1 Reply
Todd_Plank
Occasional Contributor

Esri is responding that this is a Bug and that newer versions of the software are not functioning as described.

I am using 3.0.2.  Esri tested in 3.1.2 and says it works in that version.

0 Kudos