Query selects distinct records by default

Avatar

Avatar

saurabhnarula

Avatar

saurabhnarula

saurabhnarula

14-02-2019

When I select data using Query from Workflow Targeting activities, then the query by default selects distinct records. What is the best way to select all records and not just distinct.

Thanks

Saurabh

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

15-02-2019

Hi,

Click 'Advanced parameters...' in the 'Additional columns' dialog, there's a checkbox to turn off DISTINCT in the select.

Thanks,

-Jon

Answers (0)