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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Exclude user if at least one condition is met in broadlogRcp

felixAgung
Level 2
Level 2

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

1 Accepted Solution
_nkur
Correct answer by
Level 3
Level 3

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

1289810_pastedImage_0.png

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.

View solution in original post

1 Reply
_nkur
Correct answer by
Level 3
Level 3

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

1289810_pastedImage_0.png

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.

View solution in original post