In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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

Challenge #496: Create the Correct Code

Chaoued
8 - Asteroid

Hello, I got the same results for TASK1, but for the second one I didn’t get the same values. However, I’m confident that my results are correct. If you notice anything different, please feel free to correct me

 

Spoiler.png

Arunkumaar
5 - Atom

just tried best to bring the expected result. hope I made it there!

Arunkumaar
5 - Atom

attaching the file there!

Joseph_Peterson
7 - Meteor

Didn't get the same percentages for task 2, but there are a few things left to interpretation:

 

I am confident the letter suffix % is 40 and not 38

 

The missing delimiters is confusing because the hint says that the 3 - 2 digit inside the code are correct, but some of them have underscores or no delimiter. I believe the 86% is if you take those into account as wrong, which is not what the hint is telling you to do. 

 

By assuming that the 3 and 2 digits in the code are always right, I get 68% are missing delimiters.

 

Spoiler
Joseph_Peterson_0-1763662394489.png

 

RoyClay
5 - Atom

Screenshot 2025-11-20 155305.png

 

REGEX_Replace(REGEX_Replace([Code], "^([[:alpha:]]+)(\d{3})(\d{2})([[:alpha:]]?)$", "$1-$2-$3-$4"),"-$", "")

 

 

 

nSpire
10 - Fireball
Spoiler
496.png

CandiceDB
Alteryx
Alteryx

My solution 😊. Like others my outputs do not match exactly.

 

Spoiler
CandiceDB_0-1763708933696.png

 

RebekaMazuchova
8 - Asteroid

I also get different results than the one provided.

barcian
5 - Atom

barcian_0-1763732996602.png

My solution is attached. My output numbers do not match the provided solution, but after careful review I stand by my solution and believe the provided answer set was erroneous.

EKasminsky
9 - Comet

Fun challenge. Wasn't as hard as I thought initially.