In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

I need to separate cases that have completed from the ongoing ones.

Apcvirgo1
7 - Meteor

I have a case study I haven't come across before, I hope someone can help.

 

Cases may have several entries (BKI 3's) until they are completed bases on the activity name Case Resolved. I need to have a list that just includes the uncompleted inquires. In the screen capture below BKI-210901000002 would be excluded as it has a Case Resolved but BKI-210901000003 would be on the list I need because there isn't.

 

Apcvirgo1_0-1632947095232.png

 

1 REPLY 1
DavidP
17 - Castor
17 - Castor

Hi @Apcvirgo1 

 

Here's how I would do it.

 

Create a filter on "Case Resolved", then use the BKI's from the true output and join to the original list. In my case the left output shows the BKI's that don't contain a "Case Resolved"

 

Sample workflow attached

 

DavidP_0-1632953010388.png

 

Labels
Top Solution Authors