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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

workflow error


Level 8

Hi Community,


I need some assistance on resolving an issue with a workflow,

The intersection is failing.




in the read audience, I am selecting my audience

In the query, I am using delivery logs under resource and target dimension


below is from properties



in the additional, I am using below fields,




in the Intersection activity, I have




when I run the workflow, it errors out at the Intersection step,


WKF-XXX Field '/@customerId' cannot be used for join with schema 'Union'.



below is the Audience content columns




Target audience
EMAIL_ADDRESS_  are having unique values.


can someone please let me know what is wrong in my set up.




9 Replies


Level 8

@johnwwilcoxmba, I tried using @Deleted Account_ in List of fields for the join for the intersection activity, I get the below error









Level 8

@johnwwilcoxmba, I am not sure what wrong I am doing, please see the details that I have currently for the additional data and join










I get the below error,


WKF-560036 Field '/@email' cannot be used for join with schema 'Union'.




Level 6
I am thinking you may need to use an enrichment activity instead of an intersection activity.


Level 6
In the enrichment step, make your query primary and uncheck Keep All additional data from the main set. Under relational definition use your Audience, then source will be @address and destination will be your additional data field. Under the Additional data tab, add a field from your audience like Demo_Code.


Level 8
@johnwwilcoxmba, if this helps in resolving, I am explaining the purpose of my WKF, there is a DM that is already delivered to an Audience and for reporting purposes we want to insert the data into Listload(cusListLoad) where we want to have data inserted/updated for the email address against the delivery ID, please if you can guide me further on this it would be really helpful.

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now