Filter data in multiple conditions

Question

Hi,

I would like to filter out data in multiple conditions with below data set:

1. GAM name is blank

2. Split_Remarks is "Roll up" and blank

3. Special target is NOT "TBS Asia" and "TBS EMEA"

IDGAM NameSplit_RemarksSpecial Target123AppleRoll UpTBS Asia 456  IRU789Amazon  CM1011 Team support TBS EMEA 1213 Team support TBS EMEA 1415Twitter Team Owner CM

Appreciate any feasible solutions.

grazitti_sapna · Answer

Hi @Yolande_Q 
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks

Filter Wf.yxzp

Raj · Answer

Please find attached

IsEmpty([GAM Name]) or IsNull([GAM Name]) && (Trim([Split_Remarks]) = "Roll Up" OR IsEmpty([Split_Remarks])) && (Trim([Special Target]) != "TBS Asia" AND Trim([Special Target]) != "TBS EMEA")

this will help.

JosephSerpis · Answer

Hi @Yolande_Q I mocked up and approach which use multiple filters as this approach is generally faster in terms of compute rather than having one complex logic formula in a single filter plus is easier to troubleshoot.

Filter_05012024.yxmd