how does the Deduplication works on export

Avatar

Avatar
Validate 1
Level 2
wkt85768776
Level 2

Likes

8 likes

Total Posts

30 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
wkt85768776
Level 2

Likes

8 likes

Total Posts

30 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
wkt85768776
Level 2

11-01-2019

Hello,

I was wondering how does the deduplication in the export data works, can anyone help me ?

1665645_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

11-01-2019

Hi,

It adds the 'distinct' modifier to the select clause of the sql (the parenthetical).

This makes it so all the fields in the extract compose a unique key that is deduped.

Thanks,

-Jon

Answers (0)