Hello all,
Attached file has input tab and output tab. Input tab is a result of an alteryx workflow I've created on my end. Every Terminal has multiple rows and a total row. For every terminal, I want to look through "Approval" column for atleast one "yes" and if found then the total row for that terminal should've approval column as "yes". If not even a single "yes" per terminal is found then the total row for that terminal needs to have approval column as "no".
For example in output tab:
Terminal 1 has all 3 rows listed as "yes" and hence the total row has a "yes". Terminal 2 has atleast one "yes" and hence the total row has a "yes". Terminal 3 has no "yes" and and hence the total row has a "no" listed.
Please let me know how to achieve this.
