When a Contact/Subscriber has multiple rows in a Data Extension, I need to be able to filter and make decisions based on a specific row (i.e., the row that qualified them for the current entry into the Journey).
All our Journey entry sources are Data Extensions, populated & updated (hourly) via SQL Query from synchronized Salesforce records. I created an Attribute Group with a "one-to-many" relationship between the MC Subscriber Key and ContactID in the data extensions.
In the sample below, I want to exit a Contact from a Journey if their HearingStatus = "Completed". But I want to keep this Contact in the Journey because Row 2 on the data extension is what is current and qualified them for re-entry.
- Filtering using Journey/Entry data does not work, because the values can change during the life of the Journey.
- Filtering using the Contact Data --> Attribute Group does not work, because it treats all rows for the ContactID the same, and if a Contact enters a Journey more than once the decision split might look at the first row instead of the second/current row.
How can I force a reference to a specific DE row in Filters, Decision Splits, and Goals? Thank you for your help!