Loading

Null Handling in CRM Analytics

Fecha de publicación: Oct 10, 2023
Descripción

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.

Solución

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:
 

 

 

Número del artículo de conocimiento

000386703

 
Cargando
Salesforce Help | Article