Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
21 - Polaris
21 - Polaris

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

Mgaurav2grt
7 - Meteor

its worked

 

Labels
Top Solution Authors