Where Condition help

[amit_saini]

Hi Folks,

How to implement below condition while loading the data:

Project Phase = “Closed”  and Project_Approval = “On Hold” or “Rejected” or “Pending” or “Cancelled”

So i should not load data if Project Phase = “Closed”  is matching with any one of Project_Approval = “On Hold” or “Rejected” or “Pending” or “Cancelled”

Regards,

AS

[sunny_talwar]

May be using Match

Where Project Phase = 'Closed' and Match(Project_Approval, 'On Hold', 'Rejected', 'Pending', 'Cancelled');

[YoussefBelloum]

Hi,

WHERE [Project Phase]=“Closed” and (Project_Approval = “On Hold” or Project_Approval = “On Hold” or Project_Approval = “Rejected” or  Project_Approval = “Pending” or  Project_Approval = “Cancelled”);

[marcus_sommer · Accepted solution]

Maybe in this way:

where not ([Project Phase] = 'Closed' and match(Project_Approval, 'On Hold', 'Rejected', 'Pending', Cancelled'))

- Marcus

[sunny_talwar]

Didn't see the not... this should work