how does the Deduplication works on export | Community
Skip to main content
wkt85768776
Level 3
January 11, 2019
Solved

how does the Deduplication works on export

  • January 11, 2019
  • 1 reply
  • 1637 views

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.
Best answer by Jonathon_wodnicki

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
January 11, 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