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.

1. Create a Basic List Merge Example.
2. 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.
3. In the Integration Procedure, delete the DRExtractAddresses component.
4. Drag a Set Values action between the DRExtractBirthdates and ListAction1 components and enter CopyList in the Element Name field.
5. Under Element Value Map, click Add New Value. Enter an Element Name of CopyBirthdates and a Value of %DRExtractBirthdates%.
6. In the List Action, under Merge Lists Order, replace DRExtractAddresses:contact with CopyBirthdates:contact.
7. Check Advanced Merge and add the following rows to the Advanced Merge Map table:

   List Key	Matching Path	Matching Group
   CopyBirthdates:contact	firstName	1
   DRExtractBirthdates:contact	firstName	1
   CopyBirthdates:contact	lastName	2
   DRExtractBirthdates:contact	lastName	2

8. 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"
       }
     ]
   }

9. To see what the list looks like without duplicates removed, in the Response Action, change ListAction1 to DRExtractBirthdates. Then click Execute on the Preview tab again.