EXPRESSION TO CHECK MULTIPLE RECORDS WITH DIFFERENT VALUES

[Anonymous]

Hi all

I have below data in table and  need a expression

To check if any one record for "result column"  having passed value than finalresult is Promoted or failed

for student id

studentid  sub    result       finalresult

1                s1     passed

1                s2     failed

1                s3    passed

2                s1    failed

2                s3   passed

3                s1   passed

3                s2   passed

3                s3   passed

4                s1   failed

4               s2   failed

4               s3   failed

Need below finalresult for each student ID

Studentid:1 ->>> atleast one subject passed hence finalresult "promoted"

2->>same as 1

3->> all subjects passed hence "promoted"

4->> final result:"Failed"

Please help to write expression to get above result

thank you

[Anonymous]

Left Join (Table)

LOAD studentid,

If(MaxString(result) = 'passed', 'promoted', 'Failed') as finalresult

Resident Table

Group By studentid;

Same script used added below two filter columns in if conditions but it's not working.Please check

Match (Location,'IND' ,'ITLY')and match( Diversity,'Asian','EUROPE')

Left Join (Table)

LOAD studentid,if (Match (Location,'IND' ,'ITLY')and match( Diversity,'Asian','EUROPE') AND

MaxString(result) = 'passed', 'promoted', 'Failed') as finalresult

Resident Table

Group By studentid;

[sunny_talwar]

You added other things to the script I gave... May be share your app or sample data with expected output to help you better

[Anonymous]

Thank so much sunny

corrected my script and it is working fine

Except one corner scenaRio some of students are absent any one subject for them the result column updated as 'Not Present'...In my requirements if any subject absent also we need to change the finalResult to promoted.

In this case ,the student who's result have 'Not Present exam

MaxString(result) will return 'Not Present and final result will updated as failed

Please have a look

[Anonymous]

Corrected string of result column  it is 'Not present' it is

'Unknown-absent' for students who are absent

MaxString(result) will returned as 'Unknown absent' and final result  updated as failed

Please have a look

[sunny_talwar]

Look where my friend? please provide a sample of what you are referring to.

Best,

Sunny