Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Filtering Data Out

DataPirate26
10 - Fireball

Hi All, 

 

I have a problem. Below I have shared 2 sample data Input and the Desired output. 

 

I want to Create a New Field New Comment Where it will check by Request no and Name. If For a Request no It has 3 different Exception names it will check under which name in the Field Filter Criteria all the Rows are Co-ordination. It will Create a New Field New Comments and update "Coordination Hours booked" only for those names. 

 

Note : If any of the Rows have Review or Processing for that Particular request no and has the same Exception name Then It will be Left Blank. Can somebody help me out with this ? Sample Dataset given below

11 REPLIES 11
Qiu
20 - Arcturus
20 - Arcturus

@DataPirate26 
Good to know.
Thank you for letting me know.

Mgaurav2grt
7 - Meteor

its worked

 

Labels