HI All,
I have a use case where i want to have a group a result based on their status (per row). If all the statuses are rejected or withdrawn it should be “Hard Delete”. On the other hand, if there’s one ‘active’ status and the rest of the statuses are rejected or withdrawn, it should be “No Delete” for Active and “Soft Delete” for rejected or withdrawn
with the workflow below you could do something like this. What it basically does is to look which unique person hast got an “Active” entry and for those we apply the Rule Engine Node to get the “No Delete” or “Soft Delete” entries and for all others which only have “Rejected” or “Withdrwan” we add a constant value to the Result column with “Hard Delete”.
