Create One Entity from Multiple Records

The data loader creates a single entity by merging multiple records that have the same crosswalk.

The example below shows some records to be uploaded:

FirstName Email Birthdate Crosswalk
John john@gmail.com 2/10/1980 ABC
Johny john@gmail.com   ABC
Floyd floyd@gmail.com 2/03/1982 XYZ

Limitation: There was a scenario when the above data was loaded using the data loader, two entities were created. For the entities with the same crosswalk, the last record was the surviving record, as it was overwriting the previous records. In the example above, while loading, the second row was overwriting the first row.

The data loader has overcome this limitation and instead of overwriting, creates a single entity by merging multiple records that have the same crosswalk. In this case, if an attribute has duplicate values, they are merged and the unique values are grouped. As a result, the attribute becomes a multi-value attribute.

Note: These records can be available in a single file or spread across multiple files. This is not applicable if you are uploading files from local file system.

Based on the example above, the first two records from the same crosswalk (ABC) are be merged into a single entity, as shown below:

FirstName Email Birthdate Crosswalk
John, Johny john@gmail.com 2/10/1980 ABC
Floyd floyd@gmail.com 2/03/1982 XYZ

The FirstName attribute that has unique values, will be grouped to have two values, John and Johny.