Alteryx Designer Desktop Discussions

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

How to flag mismatches?

ivoiculescu2020
8 - Asteroid

Hello team,

 

I need your help again with the following issue:

 

I need to run a monthly report on all the users in a system and I need to flag all/any user that has both active roles and it's deactivated. The only workaround I found is to use the Summarize (group by username) and concatenate the users' roles and then filter for each user that is both deactivated and has active role. However, I never know how many users will actually be in this situation. For example, I found only one user this month that has both an active role and his acct was already inactive. But it may be more than one.

 

Is there an easier way to do this?

 

Thank you!

 

Kind regards,

Ioana

3 REPLIES 3
OTrieger
12 - Quasar

@ivoiculescu2020 
You can add Distinct Count to the groups on employee and anyone and then filter it if Equals 1, if not you will have all those that have 2 different statuses.

ivoiculescu2020
8 - Asteroid

@OTrieger 

I think it works!!! thank you so much for your prompt reply.

I do appreciate your time and your assistance.

Have a wonderful day!

OTrieger
12 - Quasar

😎happy to hear it!

Labels
Top Solution Authors