Honoring default values when loading data into a file geodatabase

Question

I have an empty file geodatabase that I am loading data into. Many of the fields in the target FGDB have default values assigned. I'd like for those to be honored when loading data. Note that the fields in question do not have corresponding fields in the data being loaded, so no values will be brought over from it. I end up with null values instead of the defaults. Is there a way to accomplish this other than calculating each field outside of the append or load commands?

RichardFairhurst · Accepted Answer

You cannot set up the Load to do what you want, since it is just like using Add field on the original table (everything comes in Null).  If the target you are loading is empty when you set the field to not allow Null values it will default to a space if it is text, or 0 if it is a number, not the default value.

If you have a lot of fields to change from Null to the default you should use a cursor, not the field calculator, since the cursor can evaluate and set every field in a record in a single pass through the records, while the field calculator has to process all of the records for each time a field is calculated.