How do I match target records via multiple fields?

To match target records using multiple fields, specify Target Matching Field as Id and use a VLOOKUP function in the field's mapping.

Example: 
VLOOKUP("PermissionSetAssignment", "Id", 
          "AssigneeId", Id, 
          "PermissionSet.Name", "pushtopics__DataSyncProStarter")
  • Target Matching Field: Id (of PermissionSetAssignment)
  • Source Object: e.g., User, using the Id field
  • Matches on: AssigneeId (User Id) and PermissionSet.Name

If multiple matches are found, use the Principal Matched Record Selection Rule to control which record is selected as needed.