Loading

Null Handling in CRM Analytics

Publiceringsdatum: Oct 10, 2023
Beskrivning

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:
 

 

 

Knowledge-artikelnummer

000386703

 
Laddar
Salesforce Help | Article