Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Query selects distinct records by default

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

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

Thanks,

-Jon

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

Hi,

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

Thanks,

-Jon