Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
Alteryx
Alteryx

A solution to last week's challenge can be found HERE!

 

Use the provided datasets to determine the name, year and issue of each comic in which Marvel characters make an appearance.  

 

cpnmarvel.gif

 

 

 

Highlighted
16 - Nebula
16 - Nebula

Here's my solution. My record count is slightly different than the provided solution but I'm ok with the differences.

Spoiler
Capture.PNG

 

Highlighted
Alteryx
Alteryx

@patrick_digan Any idea where the difference emerged?  I'll re-visit my solution, too. 

Highlighted
14 - Magnetar
14 - Magnetar

My solution! 

 

Spoiler
I feel like the logic used for parsing out years & issue numbers could have been tackled a few different ways, but I eventually figured out the right combo to get me to the same answer.

WeeklyChallenge162.JPG

Cheers!

NJ 

Highlighted
13 - Pulsar

The only spoilers I want to see are for this challenge.  Seeing Avengers Endgame tonight!

 

Spoiler
Workflow 162.GIF

 

Highlighted
Alteryx Partner

My Solution :)

 

 

11 - Bolide

 

Spoiler
Capture.PNG

 

 

Highlighted
13 - Pulsar

@patrick_digan  - I ran into the same issue with record count on my first pass at completing this challenge.  More info in the spoiler in case someone else wants to solve this on their own.

Spoiler
If you look at your results (for example rows 456 - 458) there are Published Years results that are incorrect.  This is due to the title having multiple hits on (\d{4}), which results in incorrect data summation.  To match the results I had to find \d{4} inside of parentheses:  \((\d{4})\).  To parse the title correctly without a trailing space it was (.*)\s\((\d{4})\)

 

Highlighted
14 - Magnetar
14 - Magnetar

My record count is also slightly off the solution (guessing it has to do with choices in cleaning up the titles)

Spoiler
image.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

About 100 records out... :/

 

Spoiler
Challenge 162 - Capture.PNG