In this article
| Table of Contents | ||||
|---|---|---|---|---|
|
...
| Parameter Name | Data Type | Description | Default Value | Example | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Label | String |
| ELT Unique | Distinct Records | ||||||||
| Get preview data | Check box |
| Not selected | Selected |
Troubleshooting
None.
Examples
Retrieving Distinct Values
We need a SELECT DISTINCT query to retrieve distinct values from a table. This example shows how we can use a combination of the ELT Select and ELT Unique Snaps to accomplish this task.
First, we build a SELECT query to read the target table. To do so, we can use an ELT Select Snap. This Snap is configured to output a SELECT * query to read the target table in the database. Additionally, this Snap is also configured to show a preview of the SELECT query's execution:
A preview of the output from the ELT Select Snap is shown below:
Then, we add an ELT Unique Snap to the ELT Select Snap. Upon execution, the ELT Unique Snap adds the SELECT DISTINCT statement to the incoming query as shown:
We can also add an ELT Insert-Select Snap downstream and write the result of this query into another table.
Downloads
| Note | ||
|---|---|---|
| ||
|
...