Dynamic Search and Rename

[mercurial_maverick]

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.

[Emil_Kos]

Hi @mercurial_maverick,

I have created a solution for you.

This was really fun:

Please mark my post as a solution if this is helpful!

[mercurial_maverick]

@Emil_Kos Is it possible to upload just the workflow alone?

[Emil_Kos · Accepted solution]

Hi,

Sorry my bad 🙂 

[mercurial_maverick]

@Emil_Kos This worked! Thank you so much!