Skip to main content
wkt85768776
Level 3
Jan 11, 2019 2:54 PM UTC
Solved

how does the Deduplication works on export

Hello,

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
Community Advisor
Jan 11, 2019 7:49 PM UTC

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
Jan 11, 2019 7:49 PM UTC

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

Translate