Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
16 - Nebula

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
16 - Nebula

Hi,

 

Sorry my bad 🙂 

mercurial_maverick
8 - Asteroid

@Emil_Kos This worked! Thank you so much!

Labels