Forum Discussion

NAl's avatar
NAl
Contributor
5 years ago

Records not marrying up based on Email

I have a pipeline which is pulling data from 2 salesforce orgs. These data sets are then combined and matched based on the email address using a sort and join (left outer) snap. The end result is an ...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
5 years ago

@NAl

If there is an match on email addresses from both orgs, then based on your logic it should go on update branch.

After the Join Snap, I suppose that you have a router snap where you are routing create/update messages. Can you please share the conditions inside the router snap?

Regards,
Spiro Taleski

  • NAl's avatar
    NAl
    Contributor
    5 years ago

    That’s correct, in our Router it’s just looking at the whether the Id is populated or not:

    $Id != null - EXISTS > go to update snap
    $Id == null - DOES NOT EXIST > go to create snap