alteryx Community

# 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.

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

Alteryx Alumni (Retired)

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.

17 - Castor

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

Spoiler

Alteryx Alumni (Retired)

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

ACE Emeritus

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.

Cheers!

NJ

14 - Magnetar

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

Spoiler

5 - Atom

My Solution :)

12 - Quasar

Spoiler

14 - Magnetar

@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})\)

15 - Aurora

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

Spoiler
16 - Nebula