Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

workflow error

Avatar

Level 9

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 6

Why aren't you joining by Email_address?

Avatar

Level 9

@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 6
Did you rename the alias under additional data to @email, then use @email for the join.

Avatar

Level 9

@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
When you loaded the audience, did you target the profile?

Avatar

Level 9
yes, the Audience has targeting dimension as Profiles(profile)

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 9
@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.