I have found a solution to my problem. I was using text field to join. It seems like there's a character limit when using text field as index for intersection. What I did was to substring the index text field into only shorter unique text. It's not ideal but it works.e.g.substring(Rtrim(Ltrim(Upper(...

Hi Anyone has experience or has any idea why two shared value from two table cannot be joined even after removing all spacing and turning everything into uppercase in the Enrichment? The intersection kept returning 0 even if the shared values are obviously the same from the interim results. Any sugg...

Thanks David. Do you know if there's a common identifier shared by event delivery and event tracking log? I have tried delivery log id but it's not shared.

Hi there,When exporting the delivery log & tracking log of event transactional email, I noticed there's no unique identifier for a contact I can use apart from the email address. Is there any unique identifier like ACS ID in event transactional log to identify a contact?Thanks!

Hi Prasanna_Soni, I'm not sure about mid sourcing server but I guess it should work the same. Best to log support ticket.

It works. Thanks so much!

Hi there, I'm trying to create dynamic audience label using the filename from file downloaded from SFTP. However the filename came up as full path. How can I substring $(vars/@filename) to leave just the filename removing the path and file extension? Thanks in advance

Hi Sumit, Thanks for your reply. I did not use service. It was global unsubscription so I just update profile to blacklist

Hi there, I have been having issue with unsubscription of certain profiles.These profiles have ACS Id and primary key like other profiles so I dont see any issue with them.However, these profiles when clicked the unsubcription link on email got opted out but they got redirected to error page instead...

Thanks @ramon_bisswanger! The import works.