Final Status Update

[Getalok]

HI Team ,

I have to calculate final status(Final Compliance)  based on another column status(Individual Subject Compliance deadline)  if student Flag is Yes in all subject (in  Individual Subject Compliance deadline) then Final Compliance will be Yes otherwise NO . Kindly guide me to get this calculation .

Student ID	Subject	Individual Subject Compliance deadline	Final Compliance
ABC12	A	Yes	NO
ABC12	B	NO	NO
DEF21	A	YES	YES
DEF21	B	YES	YES

Thanks

[Taoufiq_Zarra]

@Getalok  One solution in load :

Input:
LOAD * INLINE [
    Student ID , Subject , Individual Subject Compliance deadline
    ABC12, A, Yes
    ABC12, B, NO
    DEF21, A, YES
    DEF21, B, YES
];
left join 
load concat([Individual Subject Compliance deadline]) as ConcatTmp, [Student ID] resident Input group by [Student ID];



final: 
noconcatenate

load [Student ID] , Subject , [Individual Subject Compliance deadline],if(wildmatch(ConcatTmp,'*NO*')>0,'NO','YES') as [Final Compliance] resident Input; 

drop table Input;

output:

[Taoufiq_Zarra · Accepted solution]

@Getalok  or in UI

Dimension:

Student ID , Subject , Individual Subject Compliance deadline

Measure :

=if(wildmatch(concat(total<[Student ID]>[Individual Subject Compliance deadline],''),'*NO*')>0,'NO','YES')

output:

[Getalok]

Thank You so much this works perfectly  @Taoufiq_Zarra