How to Toggle SELECT and SELECT DISTINCT in Report Builder's SQL

Summary

Sometimes you may want to show or remove the duplicate entries from a report's output. This is functionally the same as the SQL commands SELECT and SELECT DISTINCT but can be toggled easily from the Yellowfin Report Builder.

Toggling Show Duplicate Records

You can toggle SELECT and SELECT DISTINCT in a reports SQL by clicking the 'Show Duplicate Records' option in the Report Builder:

Off (Default) = SELECT DISTINCT

On = SELECT

Is this article helpful?
1 0 0