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 Certified Partner

My solution:

Spoiler
challenge 162.jpg
Highlighted
17 - Castor
17 - Castor

Of course the real question is...what happened to Millie the Model and the Two-Gun Kid

 

YearlyPopularity.png

 

Spoiler
WF.png


Result.png

 

 

Dan

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

This week, I've learned the names of numerous comic characters I'd never heard before ... Beside that, my record count is not exactly identical to the solution, difference seems to be caused by handling of issues like "12.1" or "0.5".

Highlighted
5 - Atom

My salutation 😉

Highlighted
8 - Asteroid

Back to challenges!

 

Spoiler
AWC_162.PNG
Highlighted
Alteryx Partner

Decided to challenge myself and do it all in only 1 regex parse. Had it match perfectly.

Spoiler
162..png

 

 

Highlighted
8 - Asteroid

My solution attached.

 

I also had the record count discrepancy due to the '0.5' and '12.1' issues.

Highlighted
12 - Quasar
12 - Quasar

Looks like you can get a different list depending on which field you parse.  I made it match the expected output.

Highlighted
Alteryx Certified Partner

Thanks for a great challenge, it was almost just like

 

SnapSnap

 

Spoiler
Okay, I must admit, I had a small challenge in getting the result to match the provided output, but in the end, nothing a little data cleansing couldn't handle, so my workflow ended looking like this:
My final workflowMy final workflow

 

and i kept more than 50% 😁

Still Climbing
/Verakso

 

 

Highlighted
8 - Asteroid

Hi! Here my solution 😞   (my record count is also slightly different, checked it 100 times but I don't see what happens)