workflow error

[mmbb110]

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

and 

EMAIL_ADDRESS_  are having unique values.

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

[johnwwilcoxmba]

Why aren't you joining by Email_address?

[mmbb110]

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

[johnwwilcoxmba]

Did you rename the alias under additional data to @email, then use @email for the join.

[mmbb110]

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

[johnwwilcoxmba]

When you loaded the audience, did you target the profile?

[mmbb110]

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

[johnwwilcoxmba]

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

[johnwwilcoxmba]

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]

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