Forum Discussion

nirupama's avatar
nirupama
New Contributor II
3 years ago
Solved

To fetch value from group by output based on different values of one field

Hello Community,

I want to fetch ESTVERSION value after performing the group by REQUESTNUM based on condition as below:
If all records having STATUS=‘ESTIMATED’ then max(ESTVERSION) else if anyone STATUS=‘ACCEPTED’ then that ESTVERSION must be fetched. Tried with router, but not able to satisfy both the requirement.

Group_By Fields output0.json (619 Bytes)
required_output.json (260 Bytes)