My business partners want an Anniversary journey (based on when a consumer came into our Welcome journey).
The welcome journey is based on campaign data from SF since we do have the MC connector.
However, when the welcome journey was set up, the team did not bring in any kind of “create date” to mark the date someone entered the welcome campaign.
The underlying DE created by the journey does not have a primary key on it. However, they do have subscriberkey which is really unique. It's just not marked as a primary key.
I don't want to create a new DE as I don't want to disrupt the welcome journey. I just want to make the welcome journey DE usable for an anniversary journey.
I was able to add a CreateDate field to the underlying DE and make it start populating with current date.
I thought I might create an SJSS script to populate create date for all the other records in the DE.
However, without a primary key, I’m not sure I can do so. Can I?