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

What's wrong with Deduplication based on Emails?

Avatar

Avatar
Give Back
Level 1
a-lopez
Level 1

Likes

0 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Validate 1
Applaud 5
Establish
View profile

Avatar
Give Back
Level 1
a-lopez
Level 1

Likes

0 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Validate 1
Applaud 5
Establish
View profile
a-lopez
Level 1

13-07-2021

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 1
Level 1
minakshis868318
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

2 solutions
Top badges earned
Affirm 1
Boost 1
View profile

Avatar
Affirm 1
Level 1
minakshis868318
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

2 solutions
Top badges earned
Affirm 1
Boost 1
View profile
minakshis868318
Level 1

19-07-2021

Hi @a-lopez- 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.

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 3
Level 2
Krishnanunni
Level 2

Likes

5 likes

Total Posts

21 posts

Correct Reply

2 solutions
Top badges earned
Affirm 3
Boost 5
Contributor
Shape 1
Boost 3
View profile

Avatar
Affirm 3
Level 2
Krishnanunni
Level 2

Likes

5 likes

Total Posts

21 posts

Correct Reply

2 solutions
Top badges earned
Affirm 3
Boost 5
Contributor
Shape 1
Boost 3
View profile
Krishnanunni
Level 2

13-07-2021

Hi @a-lopez ,

 

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