IF function multiple rows/columns

[NatasjavdHengel]

Hi everyone,

I need some help with Alteryx. For a client I need to check whether every workflow (having a unique doc. nr) has two or more different people involved. I wanted to you an if-function but I have no clue how to this for this file. An example of the data is shown below.

So as you can see for doc. nr. 417 it is the same person who performed several tasks in the workflow, but for doc.nr. 9746 there are multiple people. 

Who can help?

Record #	Workflow	Name employee	Doc. nr
1	53	Mart	417
2	53	Mart	417
3	900033	Sebastian	9746
4	900033	Marie	9746
5	900033	Sebastian	9746
6	1101	Patty	101
7	1101	Patty	101
8	1101	Mark	101
9	1101	Patty	101

[TomWelgemoed · Accepted solution]

Hi,

Because you have the document number, I think you can just do a distinct count on the number of people involved with the document.

Screenshot below & example attached.

Best,

Tom

[NatasjavdHengel · Accepted solution]

 Hi Tom!

Thank you so much!

Kind regards,

Natasja

[TomWelgemoed · Accepted solution]

Hi @NatasjavdHengel ,

Glad it helped!

Would you mind to mark the response as a Solution?

Thanks,

Tom