Exclude user if at least one condition is met in broadlogRcp | Community
Skip to main content
F
felixAgung
Level 2
August 31, 2017
Solved

Exclude user if at least one condition is met in broadlogRcp

  • August 31, 2017
  • 1 reply
  • 1905 views

Hi There,

I'm trying to filter recipient based on their broadlogRcp.

for example:

1 User have :

- delivery a

- delivery b

- delivery c

How can I say that, if 'delivery b' exist in that user's 'broadlogRcp', excludes that user all together.

so if targeting dimension have:

User a -

- delivery a

- delivery b

- delivery c

User b -

- delivery a

- delivery c

The filter will return with JUST 'User b'. Any help would be appreciated.

Regards,

Felix

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _nkur

Hi Felix,

You can do it either of 2 ways

1. Using Recipient as Filtering Dimension and using 'Don't exists such as' query on broadlogRcp. Below screenshot

2.Starting BroadlogRcp as filtering dimension and than changing dimension back to recipient.

I prefer option 2 as option 1 is sub query execution and sub queries are know for there performance hit.

Let me know if you need more details on any of these options.

Regards,

Ankur A.

1 reply

_nkur
_nkurAccepted solution
Level 2
August 31, 2017

Hi Felix,

You can do it either of 2 ways

1. Using Recipient as Filtering Dimension and using 'Don't exists such as' query on broadlogRcp. Below screenshot

2.Starting BroadlogRcp as filtering dimension and than changing dimension back to recipient.

I prefer option 2 as option 1 is sub query execution and sub queries are know for there performance hit.

Let me know if you need more details on any of these options.

Regards,

Ankur A.

Terms & ConditionsAccessibility statement

Loading footer...