how does the Deduplication works on export

[wkt85768776]

Hello,

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

[Jonathon_wodnicki · Accepted solution]

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