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

Avatar

Level 8

Hi Community,

 

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

The intersection is failing.

 

mmbb110_0-1627661553206.png

 

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

mmbb110_2-1627662619525.png

 

in the additional, I am using below fields,

 

mmbb110_3-1627662674438.png

 

in the Intersection activity, I have

 

mmbb110_4-1627662808260.png

 

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

 

mmbb110_6-1627663141985.png

 

Target audience
and 
EMAIL_ADDRESS_  are having unique values.

 

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

 

 

 

9 Replies

Avatar

Level 8

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

 

mmbb110_1-1627665871990.png

 

 

mmbb110_0-1627665835766.png

 

 

Avatar

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

 

 

mmbb110_0-1627668235789.png

 

 

mmbb110_1-1627668272025.png

 

 

 

I get the below error,

 

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

 

 

Avatar

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

Avatar

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.

Avatar

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