Adding filter with OR condition in Segmentation Profile in SAP Marketing Cloud.

[former_member522687]

Hello Experts,

We have a business case wherein, We have to add filter with following logic in Segmentation Profile.

( country = USA OR Canada ) OR ( ID Origin = A )

but, when I added filter for country as USA & Canada and ID origin as A. It's working as follows...

( country = USA OR Canada ) AND ( ID Origin = A )

Could you please suggest me on how to add OR logic between 2 different fields. There is no option to choose OR condition.

I'm using SAP Marketing Cloud 1811.

Thanks,

Siddu

[former_member226 · Accepted solution]

Hi Siddu,

Can you please try to use SET operations as follow:

1. Create a segment at "root" where "country = USA OR Canada".

2. Create another segment at "root" where "ID Origin = A".

3. Now drop either segment created in point 2 to 1 or Point 1 to 2 and do a "Merge" Operation which is equivalent to "country = USA OR Canada ) OR ( ID Origin = A )"

A sample for same is as attached.

Thanks

Saurabh

[former_member522687 · Accepted solution]

Hi Saurabh,

Thanks for suggestion, This is possible while creating segmentation models. But, We need to implement same filtering logic you shown while creating segmentation profiles itself. Please suggest.

(country = USA OR Canada ) OR ( ID Origin = A)

Thanks,

Siddu

[former_member226 · Accepted solution]

Hi Siddu,

Unfortunately, That,s is not possible as of now and as per my understanding using Segmentation Configuration. You can put a idea HERE.

However, As a workaround you can try to create a Public "Building Block" and consume the same as a first step for segmentation.

Thanks

Saurabh

[former_member522687 · Accepted solution]

Thanks for the inputs Saurabh.