Keep all results from two populations

Avatar

Avatar
Validate 1
Level 1
SKUCCiaranC
Level 1

Likes

2 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
SKUCCiaranC
Level 1

Likes

2 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
SKUCCiaranC
Level 1

31-05-2018

System Details: Adobe Campaign Version 6.1.0 (Neolane)

I have a workflow with two separate populations, coming from two different schemas; one of which is the out of the box Recipients schema, the other is a custom one that we have built to handle event booking data; 'Participation'.

Basically, I need to be able to output into one file results from fields in both the schemas, without restricting the output to the population of either (i.e. no 'Primary set').

There are keys which could be used to link the two populations, however, the primary key from Recipients won't always be present in Participation and vice versa.

If I was working in SQL, I'd use a union or full outer, as appropriate, but I'm struggling to find the equivalent in Adobe Campaign.

I have a feeling that the solution is probably something to do with an enrichment but I'm at a bit of a loss at the moment.

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

03-12-2018

Hi Ciaran,

You can still use Union with different primary keys by selecting a different Reconciliation type.

See 4 here: Adobe Campaign Help | Union

All the best,

Pablo

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
SKUCCiaranC
Level 1

Likes

2 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
SKUCCiaranC
Level 1

Likes

2 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
SKUCCiaranC
Level 1

03-12-2018

Hi Pablo,

I'm aware that I can use any action from the left sidebar, my question was about which one should be used specifically and in which way.

A union isn't an option since the two incoming populations are from different schemas and have different primary keys.

C

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 Ciaran,

You can use Union or any other action from the left sidebar as needed on Adobe Campaign Classic.

Screen Shot 2018-11-26 at 1.55.53 PM.png

I hope this helps!

All the best,

Pablo