Expand my Community achievements bar.

SOLVED

Extracting Info from 2 Data Tables in Campaign Standard

Avatar

Level 6

Hi all,

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:

  • Profiles: This table holds all of the profile and subscription data on the contact
  • Professionals: This table holds records of all the individual professionals that contacts can be linked to (Fields include Pro ID, Pro Email, Pro First Name, Pro Last Name)
  • Related Professional: This table holds the link between the two, so the customer email field, and the professional ID make the link

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.

Many thanks,

Bob

1 Accepted Solution

Avatar

Correct answer by
Level 6

If anyone is interested, below is a screenshot of the workflow that solved my problem.

1502172_pastedImage_1.png

View solution in original post

1 Reply

Avatar

Correct answer by
Level 6

If anyone is interested, below is a screenshot of the workflow that solved my problem.

1502172_pastedImage_1.png