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

wkt85768776
Level 3
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
Jonathon_wodnicki
Correct answer by
Community Advisor
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
Jonathon_wodnicki
Correct answer by
Community Advisor
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