Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe in this way:
where not ([Project Phase] = 'Closed' and match(Project_Approval, 'On Hold', 'Rejected', 'Pending', Cancelled'))
- Marcus
May be using Match
Where Project Phase = 'Closed' and Match(Project_Approval, 'On Hold', 'Rejected', 'Pending', 'Cancelled');
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”);
Maybe in this way:
where not ([Project Phase] = 'Closed' and match(Project_Approval, 'On Hold', 'Rejected', 'Pending', Cancelled'))
- Marcus
Didn't see the not... this should work