Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I'm late to the party, so I figured I would have fun with Alteryx Abacus functions to reduce the number of tools.
My solution.
Spoiler
Workflow
Multi-Row formula Tool
ID = IF StartsWith([Field1], "ID ") THEN GetWord([Field1], 1) ELSE [Row-1:ID] ENDIF
Filter Tool(1)
Contains([Field1],"PSWD-VIO")
Formula Tool(1)
ToNumber(REGEX_Replace([Field1], ".*PSWD-VIO\((\d+)\).*", "$1"))
Filter Tool(2)
Contains([Field1],"SEC-VIO")
Formula Tool(2)
ToNumber(REGEX_Replace([Field1], ".*SEC-VIO\((\d+)\).*", "$1"))
Multi-Row formula Tool
ID = IF StartsWith([Field1], "ID ") THEN GetWord([Field1], 1) ELSE [Row-1:ID] ENDIF
Filter Tool(1)
Contains([Field1],"PSWD-VIO")
Formula Tool(1)
ToNumber(REGEX_Replace([Field1], ".*PSWD-VIO\((\d+)\).*", "$1"))
Filter Tool(2)
Contains([Field1],"SEC-VIO")
Formula Tool(2)
ToNumber(REGEX_Replace([Field1], ".*SEC-VIO\((\d+)\).*", "$1"))
