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
BedrockMission!

Learn more

View all

Sign in to view all badges

workflow error

mmbb110
Level 8
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
johnwwilcoxmba
Level 5
Level 5

Why aren't you joining by Email_address?

mmbb110
Level 8
Level 8

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

 

mmbb110_1-1627665871990.png

 

 

mmbb110_0-1627665835766.png

 

 

johnwwilcoxmba
Level 5
Level 5
Did you rename the alias under additional data to @email, then use @email for the join.
mmbb110
Level 8
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'.

 

 

johnwwilcoxmba
Level 5
Level 5
When you loaded the audience, did you target the profile?
mmbb110
Level 8
Level 8
yes, the Audience has targeting dimension as Profiles(profile)
johnwwilcoxmba
Level 5
Level 5
I am thinking you may need to use an enrichment activity instead of an intersection activity.
johnwwilcoxmba
Level 5
Level 5
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.
mmbb110
Level 8
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.