Now that it's live, don't forget to accept your certification badge on Credly today! Learn more 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