Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge comes to us from @NicoleJohnson
Thank you for your contribution, Nicole!
Picture yourself as an auditor within a prominent financial institution. Your primary duty involves performing meticulous security audits across various software applications. This entails deciphering the extent of access granted to individual users based on the last password update and identifying instances of any breaches in security protocols.
In this challenge, your task is to determine the number of password and security violations attributable to each user. The dataset you are working with contains data for three distinct users. However, there is a slight complication: all the pertinent information is consolidated within a single column.
Hint: The number of password or security violations is indicated in parentheses following PSWD-VIO and SEC-VIO. For example, PSWD-VIO(2) indicates the user has two password violations and SEC-VIO(3) indicates the user has three security violations.
Hey @braveraj j, there might be a fancier way to solve this, BUT you nailed the task with your skills, and that's the beauty of Designer – it's democratic.
You can tackle the same problem with just one or two tools or use many tools and still achieve the same result!
Your solution is awesome, by the way!
Truly inspiring!
Sylvia
@patrick_digan , seriously? Only two tools????
You absolutely aced it! I love the formulas you applied; I never even considered that approach.
Thanks a bunch for sharing!
Sylvia
Maybe too many tools, could parse in just one formula.
You rock @PhilipMannering!