Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Extracting Info from 2 Data Tables in Campaign Standard

bobbyjss
Community Advisor
Community Advisor

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
bobbyjss
Correct answer by
Community Advisor
Community Advisor

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
bobbyjss
Correct answer by
Community Advisor
Community Advisor

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

1502172_pastedImage_1.png

View solution in original post