community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

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

Bolide

My solution. I was able to match the record count in the solution @ChristineB. It was a bit challenging to get the exact match, but finally figured it out.

Spoiler
I had struggled with some of the titles that have an #8203 in the title looking like some sort of symbol change that I had to adjust.

Challenge 162.PNG

 

Asteroid

Here is my solution...

Meteoroid

Here is my solution.

Asteroid

My solution..  We use Alteryx.. We are all super heros!!  :-)

Spoiler
Challenge_162_PD_Spoiler.JPG
Alteryx Partner

Here You Go. 
Just started the weekly challenge. #WhateverItTakes

Meteor

Here Below My Solution

 

Asteroid

Christine,

 

My submission is attached.

-I also figured out why the record count was slightly different for most.

-The solution truncates some of the issue numbers, as #13 versus 13, 13.3, and 13.4 as in the case of Red Hulk.

-So, if you want to be particular about it, the solution does ask for every issue that the Character appeared in and 13 is different from 13.3 and 13.4 as these were slightly different updates or reprints (attached are all three covers)

-In total there were about 58 count of discrepancies.

-I used the summarize tool to count by number of issues by Character.

-Please let me know what everyone thinks and if my methodology or rationality is off.

-Cheers!

 

Matt

Red Hulk Combo.png

Asteroid

Fun challenge, @ChristineB   I couldn't bring myself to add the # sign to the issue and foul up the clean data.  Here is my solution:

 

 

Spoiler
162-MP.png

I came up with a slight difference in count as well.  I noted there were issues with Variant in the title, which were essentially duplicates and accounted for around 3000 issues.  But I still didn't get precisely the challenge results, either.  There were comics with no issue or year and highly similar names like these, which were also problematic (I didn't try to solve for these): 

 

 

162-dups.png

 

Thanks for the exercise!

Atom

Here's my solution, was good opportunity to dabble into some regex :)

 

 

Atom

Here's my solution, was a good opportunity to dabble into some regex :)