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.