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

SOLVED

What's wrong with Deduplication based on Emails?

Avatar

Level 2

Hi all!

 

I've been working on updating recipients with a Targeting workflow which includes a Data loading (file) activity to sum to my recipients table, and this is followed by a Deduplication activity before adding those new profiles to a list and updating them.

 

On the Deduplication activity I selected the Temporary schema so I could deduplicate my loaded file, and I am selecting the email as my attribute to identify duplicates.

 

When I run the workflow it says: Attribute 'email' unknown XTK-170036. Unable to parse expression '@email'. Someone know why could I be getting this error?

 

I would appreciate your help a lot. Best!

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi @andregonzalez- In the file uploaded in the Data file loading activity- please check the data type & name of the field which is having email address. Also, in the deduplication activity, also please select the same field name.

View solution in original post

4 Replies

Avatar

Level 4

Hi @andregonzalez ,

 

Have you selected the temporary schema in the dropdown as well (as in screenshot)?

Krishnanunni_0-1626241175486.png


If you already have set this, please check the expression added in deduplication. Usually when adding columns from a data loading activity, we don't have to use the '@' in the expression. You may open the 'Edit expression' and select the email column from there.

Krishnanunni_0-1626241253008.png

 

Avatar

Level 2

Hi @Krishnanunni,

 

That's right, I had selected  the temporary schema in the dropdown as in your screenshot, and selected the email expression there as well.

 

I haven't found the solution to this error yet 😞 it seems right to me, but I'm thinking that maybe this email field doesn't work for deduplication, even though all of the profiles that I am uploading has it and the column is well identified.

 

Thank you for this possible solution 🙂 Have a great day!

 

 

Avatar

Level 4
Hi @andregonzalez, If it is still not resolved, could you please share some screenshots so that we might be able to find the root cause. We usually use the data loading and deduplication activities together.

Avatar

Correct answer by
Level 3

Hi @andregonzalez- In the file uploaded in the Data file loading activity- please check the data type & name of the field which is having email address. Also, in the deduplication activity, also please select the same field name.