You are here:
Use Advanced List Merge to Remove Duplicates (Managed Package)
For the managed package runtime, the next Integration Procedure uses the Advanced Merge feature to remove duplicates from a list.
This information is for Omnistudio for Managed Packages. For Omnistudio on standard runtime, see Omnistudio Help.
To download a data pack of this example for Omnistudio for Managed Packages, click here.
- Create a Basic List Merge Example.
- Pick one of the Contacts that the basic list merge example retrieves and create another contact with the same Account, first name, and last name.
- In the Integration Procedure, delete the DRExtractAddresses component.
- Drag a Set Values action between the DRExtractBirthdates and ListAction1 components and enter CopyList in the Element Name field.
- Under Element Value Map, click Add New Value. Enter an Element Name of CopyBirthdates and a Value of %DRExtractBirthdates%.
-
In the List Action, under Merge Lists Order, replace
DRExtractAddresses:contactwith CopyBirthdates:contact. -
Check Advanced Merge and add the following rows to the
Advanced Merge Map table:
List Key
Matching Path
Matching Group
CopyBirthdates:contactfirstName1DRExtractBirthdates:contactfirstName1CopyBirthdates:contactlastName2DRExtractBirthdates:contactlastName2 -
On the Preview tab, click Execute. The output looks
something like this, with no duplicates:
{ "contactMerge": [ { "birthdate": "1975-10-03", "lastName": "Jones", "id": "0036100001E5xrWAAR", "firstName": "Cathy" }, { "birthdate": "1976-10-04", "lastName": "Jones", "id": "0036100001E5xrvAAB", "firstName": "Doug" }, { "birthdate": "1973-10-01", "lastName": "Smith", "id": "0036100001E5xqnAAB", "firstName": "Albert" }, { "birthdate": "1974-10-02", "lastName": "Smith", "id": "0036100001E5xr2AAB", "firstName": "Ben" } ] } -
To see what the list looks like without duplicates removed, in the Response
Action, change
ListAction1to DRExtractBirthdates. Then click Execute on the Preview tab again.
