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

how does the Deduplication works on export

Avatar

Level 3

Hello,

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

1665645_pastedImage_0.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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