0

I have a Journey where it does a decision split based on a Data Extension Contract Type Field= "Commercial". I am using the "Contact data" evaluation option.

I have a primary key based on the ContractID, so it is unique and will only be present in the data once, however a person may be in the data extension multiple times in a year's period with different Contract IDs.

I have 1:N between CustomerDE and ContractDE in Attribute Group.

How should I use attribute-to-attribute comparison in decision splits?

2
  • What is your problem? What do you want to achieve? I don't get it if you only describe your data relationship Nov 16, 2020 at 10:54
  • How can I recall the Commercial value in the decision split, if my subscriber is present several times in that DE and may have other values ​​in the type of contract.
    – Mary jON
    Nov 16, 2020 at 11:29

2 Answers 2

0

Assuming, your Contract DE is your Entry DE and it has ContactId which relates to Subscriber Key, then whenever the evaluation will be made in the decision split, it will for that contactId. The evaluation is not for the ContractId, but it is for the contact Id(or whichever field relates to subscriber key) Depending on your journey settings, the contact may enter again.

3
  • so I will use attribute-to-attribute comparison in this way; Contract Type Field= "Commercial" AND contactID(Jurneydata)= Contact I (contact data)
    – Mary jON
    Nov 16, 2020 at 13:37
  • Yes, the Contact is evaluated in decision splits, and not Contract, but while all of the above is true, it doesn't answer the question...
    – LimeWeb
    Oct 31, 2021 at 18:44
  • @MaryjON, comparing on the ContactID will not address the one-to-many relationship.
    – LimeWeb
    Oct 31, 2021 at 18:53
2

There are a lot of glitches with this functionality (Nov. 2021) Read carefully.

You say : 1:N between CustomerDE and ContractDE

So a Contact can have multiple Contracts (One to Many). In this case, it means that a Contact could be in the journey multiple times, triggered by different Contracts.

You'll have to follow these instructions carefully (because of glitches). In other words, (A AND B) in JB is different than (B AND A)...

  1. Make sure that Contracts are mapped 1:Many (infinity sign in SFMC) in the Contact Model. You'll have ContactKey on the left, and Conatct_Id (or equivilant in the Contract DE) on the right.
  2. Configure the Decision split. First Condition: (Must be first or it can glitch in evalutation). Contract ID (from Contact Data) = ContractID (Journey Data) AND Contract Type Field (Contact Data) = "Commercial"
  3. Notice in #2 above that on the left you'd put the Contact Data, and on the right the Journey Data. Some users have reported glitches if you swap these.

Other glitches reported if you have more than one path to the Data Extension in Data Designer. Source: https://trailblazer.salesforce.com/issues_view?id=a1p3A000001YomgQAC&title=attribute-to-attribute-comparison-does-not-always-work-when-contact-data-is-on-the-right-side

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .