how does the Deduplication works on export | Community
Skip to main content
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
New Participant
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
Jonathon_wodnickiAccepted solution
New Participant
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