Null Handling in CRM Analytics

Fix errors caused by including null fields or columns

1. Make sure the field or column has at least one non-null value in the source data. If you do not need the field or column in CRM Analytics, do not include it in the dataflow sfdcDigest node or external data file.

2. Provide a default value for the field or column:
 

• For dataflow fields: Use the defaultValue override in the dataflow definition. See more details in Overriding Salesforce Field Metadata
• For external data columns: Use the defaultValue override in the metadata schema. See more details in the "Fields" section of External Data Metadata Format Reference