Sign in to Community
Sign in to view all badges
Within my data a customer can have numerous activity IDs assigned to them. They're assigned a new ID for each activity that they complete on our website.
Each activity ID has an activity date/time attached to it. How can I add an activity ID as Additional Data within an enrichment that is the first activity ID of any given day?
Furthermore, a customer is also given an IdentityID
So the data would look like this. How would I add only ActivityID 011d to the data within the workflow?
Select min(@identityId), min(@activityId), min(@activityDate) and then group by DateOnly(@activityDate).
NB this assumes @activityID is monotonically increasing.