Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
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