Importing Data

[Andre8]

Hello, I am attempting to import data but for some records there's a null value so the record isn't being created. Ex: I am importing  data that includes city, state and country, since the state field is null but required to create the record, the record doesn't get created. Is there a way to make the import create the record?

In order for the record to be created, the state is required

[cp11 · Accepted solution]

Ideally you would tell the source record provider that the State field is a required field and enforce data integrity while pulling in data. Otherwise you end up having a bunch of records with mandatory fields not populated and your data is not clean

Check the field in the transform map called "Enforce mandatory fields"