Alteryx Designer Desktop Discussions

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

I am trying to find out the duplicate contact(email) list based on the cases count

Hi,

 

I am trying to find out the duplicate contact(email) list based on the cases count.

 

I have a list of duplicate contacts in one file and another one is list of cases file. I need to match the contacts and cases based on contact ID. then I need to find out how many cases is having each contact?

 

can somebody help on it?

1 REPLY 1
caltang
17 - Castor
17 - Castor

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels