How to flag mismatches?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Preparation
- Regex
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think it works!!! thank you so much for your prompt reply.
I do appreciate your time and your assistance.
Have a wonderful day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
😎happy to hear it!
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)