Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

You can use this Snap remove duplicates from the outputs of any ELT Snap such as ELT Select, ELT Intersect, and ELT Join. 

Prerequisites

None.

Limitations

...

None.

Known Issues

Multiexcerpt include macro
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 1
  • Max: 1
  • ELT Select
  • ELT Intersect
  • ELT Aggregate
The SQL query in which you want to add the SELECT DISTINCT statement. 
Output

Document

  • Min: 1
  • Max: 1
  • ELT Insert-Select
  • ELT Merge Into
The SELECT DISTINCT statement added to the incoming query. 

...