Loading

Null Handling in CRM Analytics

Udgivelsesdato: Oct 10, 2023
Beskrivelse

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.

Løsning

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:
 

 

 

Vidensartikelnummer

000386703

 
Indlæser
Salesforce Help | Article