I'm appending data in my script and some of the source data has nulls in fields that are required. The script runs successfully but those features do not get appended.
When I run the tool in ArcMap, I get
warning 000596 - "This warning will occur when attempting to add a value to a field that is inappropriate for that value. For instance a text with a width of 10 cannot be merged into a field that has a width of 5... This warning will also result from adding a null value to a field that does not support null values."
The offered solution is
"When dealing with nulls, the Preserve Nulls environment can be turned on or off to control whether nulls are preserved in the output. If turned off, the tool used will attempt to add null values to a field or format that will not accept them."
I cannot find the Preserve Nulls environment setting.
I am on version 10.3.1
The reason I want to preserve the nulls (and keep the field non-nullable) is that this data will be edited in Collector and I want the user to be forced to correct the error when they edit that feature. The alternative I may pursue is to put a value in the fields that is outside of the domain, which will also force the user to correct the data in Collector, however I'm short on time and there are a lot of fields I will need to do this for. That is why the Preserve Nulls setting appealed to me.