Loading

Null Handling in CRM Analytics

Date de publication: Oct 10, 2023
Description

CRM Analytics can use data from Salesforce or from an external data source. To prevent data quality issues, CRM Analytics will disregard any fields in Salesforce (or columns in external data) that are entirely null.

The null field or column will not exist in the dataset, and references to that field or column in a dataflow transformation, lens, or dashboard will cause errors.

Résolution

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:
 

 

 

Numéro d’article de la base de connaissances

000386703

 
Chargement
Salesforce Help | Article