Create One Entity from Multiple Records
Learn about creating a single entity by merging multiple records that have the same crosswalk in the Data Loader.
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 | 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.
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 | 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.