I'm attempting to create a Journey Activity tracker for a DE with a Composite Primary key of [Subscriber Key], ContractID, and ContactId. Here is what I've attempted to insert within each email and it works great at the first instance for a [Subscriber Key]/ContractId/ContactId combination. However, once I attempt to add additional rows to the DE/Journey, which have the same [Subscriber Key] and ContactID but a different ContractId, the upsert updates the original instance of [Subscriber Key]/ContractID/ContactId instead of the new record. What am I missing or misunderstanding?
%%[ VAR @contractId, @contactId, @subscriberKey
SET @contractID = AttributeValue('ContractId') SET @contactID = AttributeValue('ContactId') SET @SubscriberKey = _subscriberkey
UpsertDE('DE_Name',3,'Subscriber Key', @SubscriberKey,'ContractId',@contractId,'ContactId',@contactId,'EM1',NOW())
Note: Subscriber Key is named as "Subscriber Key" within the Database and I've also checked and re-checked naming for the fields for ContractId and ContactId.