What's wrong with Deduplication based on Emails? | Community
Skip to main content
A
andregonzalez
Level 2
July 14, 2021
Solved

What's wrong with Deduplication based on Emails?

  • July 14, 2021
  • 2 replies
  • 1815 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by minakshis868318

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.

2 replies

Krishnanunni
Krishnanunni
Level 4
July 14, 2021

Hi @andregonzalez ,

 

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


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
    Krishnanunni
    Level 4
    July 15, 2021
    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.
    M
    minakshis868318Accepted solution
    Level 2
    July 19, 2021

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...