Background: We have a Journey that is triggered by data extension called CustomerWelcomeDE which has cust_id as contactkey and two other fields service_id and email_id.
Journey Entry source DE: CustomerWelcomeDE Fields: cust_id, service_id, email_id cust_id is the contact key here.
MasterDE: ServiceDE Fields: cust_id, service_id, status
Our Problem: Once the customer enters the journey and is a particular step we need update ServiceDE, status field corresponding to the same cust_id, service_id that has entered the journey.
Here is the contact builder design using Attribute group.
Contact <--linked on cust_id-->CustomerWelcomeDE<--linked on cust_id,service_id-->ServiceDE
Problem is the ServiceDE contains multiple entries for the same cust_id and the journey is randomly picking and updating wrong records.
The journey should only update a record in ServiceDE when cust_id and service_id matches with Entry data.
This is such a simple thing but we are not finding any way to update the correct record. Would high appreciate if anyone can help solve this issue.