Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am using below condition
if(match(ProductType,'OEIC','ISA') and WildMatch(Department,'FM*','Outsourced Provider – AIGSL*','REAL ASSETS*'),'OEIC FM')
there is match condition between PRODUCT=oeic AND dEPARTMENT='Outsourced Provider -AIGSL)
it is showing empty.
Might be some of the condition is not fulfilled, share the sample data
Do you have a space between - and AIGSL or not? You match expression includes a space, but the next row doesn't
Department:
LOAD
DID,
Department,
if(IsThirdParty=-1,'Yes',if(IsThirdParty=0,'No','N/A')) as IsThirdParty,
OrderBy
FROM [lib://Mandate QVD Generator (avivagroup_avelamuri)/dataREDDepartment.qvd]
(qvd) where if(WildMatch(Department, 'FM*','Outsourced Provider –AIGSL*','REAL ASSETS*'),'OEIC FM');
I am using above condition on table but it is showing all Departments whic didn't mentioned in condition also
This looks like a different question from the one your initially asked. Is the first issue resolved now?
You didn't mentioned where condition correctly it seems
You have used
where if(WildMatch(Department, 'FM*','Outsourced Provider –AIGSL*','REAL ASSETS*'),'OEIC FM');
Try this
where enter dim name= if(WildMatch(Department, 'FM*','Outsourced Provider –AIGSL*','REAL ASSETS*'),'OEIC FM');
Also as Sunny mentioned , please check if you are using correct field values without space..
Thanks it worked for me
@Abhi999 please close the thread by marking accepted as a solution.