Selecting the first of several customer references

[thomash82948276]

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?

IdentityID	ActivityID	Activity Date Time
123	011d	03/13/19,12:00AM
123	012s	03/13/19,12:01AM
123	013o	03/13/19,12:02AM
123	014pi	03/13/19,12:03AM
123	015uj	03/13/19,12:04AM
123	016mq	03/13/19,12:05AM
123	017hjk	03/13/19,12:06AM
123	018upo	03/13/19,12:07AM

[Jonathon_wodnicki · Accepted solution]

Hi,

Select min(@identityId), min(@activityId), min(@activityDate) and then group by DateOnly(@activityDate).

NB this assumes @activityID is monotonically increasing.

Thanks,

-Jon