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

How to Join Tables together in a workflow Query?

Avatar

Avatar
Validate 1
Level 1
adamk81589338
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
adamk81589338
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
adamk81589338
Level 1

01-08-2018

This is a followup question to https://forums.adobe.com/message/10531456#10531456

This is where the information I require currently resides:

savedDataList (from a ListUpdate Action)

has many columns, one of which is the DeliveryID

trackingLogRcp

has the tracking data for opens and clicks

messages

has the the timestamp related to delivered at

The next step I need to take is within a Workflow, I must be able to add a Query that can target the Deliveries for those sent within the last 7 days. With this in hand, I need to do an inner join on this data to my savedDataList to collect the columns for each send that has been logged here. I then need to join my data list with the trackingLogRcp to also get the open/click information. Once all of this has been gathered, I need to save these columns into a file so that they can be exported into another system.

I would like some assistance in constructing this query. I cannot seem to join two tables together, (or determine where in the UI I would even select the table to be joined) however I am under the impression it is doable.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

26-11-2018

Hi Adam,

It seems you need to use AND-join: Adobe Campaign Help | AND-join

If not, please try other possible functions: Adobe Campaign Help | List of functions

I hope this helps!

All the best,

Pablo

Answers (0)