Skip to main content
lulugw
Level 2
Apr 23, 2020 11:20 AM UTC
Solved

Predefined Fitlers: Result contains duplicated records

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)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
Community Advisor
Apr 24, 2020 5:59 PM UTC

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 in thread

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
Apr 24, 2020 5:59 PM UTC

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

Translate
    lulugwAuthor
    Level 2
    Apr 27, 2020 8:30 AM UTC

    Thanks Jon.

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

     

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...