Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic Search and Rename

mercurial_maverick
8 - Asteroid

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.

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi @mercurial_maverick,

 

I have created a solution for you.

Emil_Kos_1-1608579226847.png

This was really fun:

 

Emil_Kos_0-1608579215620.png

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

mercurial_maverick
8 - Asteroid

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

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sorry my bad 🙂 

mercurial_maverick
8 - Asteroid

@Emil_Kos This worked! Thank you so much!

Labels