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

Predefined Fitlers: Result contains duplicated records

Avatar

Level 2

Hello,

I have a predefined filter that contains two sub-filters in the definition. When I inspect the result of the new filter, I see duplicated records.

Is there some automatic setting/way to make sure that a pre-defined filter only contains distinct data?

 

(without actually modifying the criteria definition)

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

Predefined filters define where clauses for queries- not select clauses.

To select distinct records, use any of these:

  • Complementary information ('select') section of the query UI, under Advanced parameters
  • Complementary information, group by
  • Deduplication activity

 

Thanks,

-Jon

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

 

Predefined filters define where clauses for queries- not select clauses.

To select distinct records, use any of these:

  • Complementary information ('select') section of the query UI, under Advanced parameters
  • Complementary information, group by
  • Deduplication activity

 

Thanks,

-Jon

Avatar

Level 2

Thanks Jon.

Not exactly what I was hoping for but clarifies the capabilities.