ArcGis Pro 2.6
I have a table in a file geodatabase that I created with a connection to a (non sde) sql database with table to table. A number of fields have empty (non null) values and I want to calculate the to <Null>. However when I try to alter those fields in the field view, I get
Error 001625 failed to alter field is nullable
Is there a way for me to make this work? I'd rather not add new fields that are nullable or create an empty table of the same schema and append the originals.
Solved! Go to Solution.
Good idea. I could put str(-9999) in the text ones. Thanks.
001625: Failed to alter field is nullable.—ArcGIS Pro | Documentation
which leads to
Alter Field (Data Management)—ArcGIS Pro | Documentation
and
field_is_nullable Specifies whether the field can contain null values. Null values are only supported for fields in a geodatabase. This option is only applicable if the input table is empty (does not contain records).
So... no
Althought putting in another values which is readily identifiable as "nodata" would be a solution (eg -99999 for integers or "someone forgot something" for text)
Good idea. I could put str(-9999) in the text ones. Thanks.
then why did you mark you answer correct?😂
correct enough....