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 #162: Mondays....they're Marvel-ous!

Ladarthure
14 - Magnetar
14 - Magnetar

My solution, I had troubles with getting the perfect match, but finally did it :) 

alexnajm
17 - Castor
17 - Castor

I did it! My records are off but I feel comfortable with the solution. I thought variants should remain as well so I left them in! :)

Hannah_Lissaman
11 - Bolide

My first time posting a Challenge solution :)

 

Like most people, I ended up with a different number of records, but as a beginner user I this a really good workout

kat
12 - Quasar

Took a bit to get the record count to align, but got there in the end :)

 

Spoiler
Challenge #162.PNG
JamesMA
Alteryx Alumni (Retired)

Fun challenge, thanks to @LukeM I learned some new skills with RegEx!

 

Spoiler
Week 162.PNG

 

 

LukeM
Moderator
Moderator
Spoiler
@JamesMA this is the RegEx I used to parse the title field into three columns.
(.+)\s\(([0-9]{4})\)\s(.+)​
kelly_gilbert
13 - Pulsar

Took me longer than I thought it would to get the parsing and sorting just right! However, this was great practice parsing (and underscored the importance of understanding the makeup of the data!)

 

Spoiler
challenge_162_workflow.PNG

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Tricky, messy data but RegEx saved the day!

Capture.PNG
HewMayTheng
5 - Atom

First time trying a Challenge solution. 

Nicoleta
6 - Meteoroid

Here is my solution. Better late than never ;))