Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #162: Mondays....they're Marvel-ous!

Highlighted
Alteryx Partner

Got within 100 records with which I'm happy

Spoiler
Challenge 162.png
Highlighted
Alteryx Partner

Got stuck on the RegEx so had to get some help, but I learned from it (which I guess is the point of these, right?).  Lots more clean-up than expected

 

Spoiler
Process
- Join three tables
- RegEx to parse title, year, and issue
- Clean-up and rename fields
- Replace title if it didn't come through in RegEx (where there was no publication year or issue)
- Clean-up nulls in Issue #
- Sort
- De-dupe
- Final clean-up

MySolution.PNG
Highlighted
Asteroid

Didn't put much effort into addressing the ~2k difference in record, but it looks like many people had difficulty here. 

The solution on the post shows an even much larger difference which I found strange. 

 

Spoiler
ZHSOL.png

Highlighted
Alteryx Partner

Had to find some help in others solutions to get my parse formula right. 

Highlighted
Asteroid
 
Highlighted
Asteroid

My Solution:

Highlighted
Asteroid
 
Highlighted
Asteroid

Regex is still hard to me.

Spoiler
Annotation 2019-12-27 202406.png
Asteroid
 
Highlighted
Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG