I'm hoping there's an easy solution to my following use case, but currently I'm drawing a blank on how to achieve it:
Goal: We want to be able to export a complete list of subscribers to a specific service, but along with profile data, we also want to be able to extract data from a separate data table (related professional).
We currently have the data stored in 3 different data tables:
I can easily create a query looking at all subscribers who also have a related professional, but we need the full list of subscribers to a particular service, regardless of whether a related professional link exists or not.
I suspect I need to somehow use the Enrichment activity but after hours of playing around with it I'm unable to achieve what I need.
Any help or suggestions greatly appreciated.
Solved! Go to Solution.