using data preparation function in order to exclude or fill in empty crmID values

Question

Hi,

I would like to import some data from Salesforce to dataset which is enabled to a profile. However some records (4 out of 10000) are empty. CrmId which is primaryId cannot be empty. Is there any way to debug this at the Adobe site. I see there options:

a) put some dummy data into my crmId - I am okay with this. However which data prep functions to use?

b) delete these rows at Adobe's side - I didnt not see any functionality for this

c) debug this at Salesforce side - it may take some time (I would not be responsible for this)

Empty records:

Thanks

Mike

Tof_Jossic · Accepted Answer

@michael_soprano regarding point (a), this post may be of interest to you.

abhinavbalooni · Answer

Hey @michael_soprano

Did you try to enable partial ingestion with the default 5 percent error threshold ? Since there are a very small number of such rows, I think you should be able to address the issue with the partial ingestion enabled.

I have assumed here that you are using batch upload.

Cheers,

Abhinav

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded