How can we make use of Data Extension Default value for field names like first name? Will the default value applies if the first name is empty?
Add a comment
|
1 Answer
I feel weird having such a short answer, but yes, it will. That is the purpose of a default value. If there is no value there, it will default to the value you provided. This is great for non-nullable fields to allow for import without requiring a value in that field and for providing an easy to search value for nullable fields to find out who does not have custom info in that field.
about defaults straight from the help pages for SFMC (https://help.exacttarget.com/en/documentation/exacttarget/subscribers/data_extensions_and_data_relationships/):
'Required fields without a value will be set to an appropriate empty default for the data type (text will default to '', numbers to 0, Booleans to false, and dates to current date). Non-required fields will receive a null value. A notification will be sent once per job when this occurs to the notification email address of the owner of the send.'
answered Feb 8, 2016 at 13:33
-
It only applies to new rows, not updates to existing rows. Commented Feb 8, 2016 at 17:51
-
correct. If you already have data in the Data Extension, they will not be affected. It is only on newly imported data. Commented Feb 8, 2016 at 19:09