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
8 - Asteroid

The isolation continues...

Highlighted
12 - Quasar

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
atcodedog05_0-1585925812004.png

 

Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590026820434.png

 

Highlighted
Alteryx Certified Partner

Here is my workflow !

Highlighted
Alteryx Partner

Not the most elegant of solution but I managed to get the correct number of records

 

Spoiler
Annotation 2020-06-03 215852.png
Highlighted
11 - Bolide
Spoiler
 
Highlighted
8 - Asteroid

My count is different as well but data looks right. 

Highlighted
7 - Meteor

Here's the solution, had an issue with row count as well. Got me stuck for a couple of attempts. Checked out the published solution, and my results seem to be in line, so let this one go.

Highlighted
8 - Asteroid

Still don't feel comfortable with RegEx.  It always takes me way too long to figure it out, and I always end up needing to look at someone else's to figure it out.  The rest was pretty straight forward.

 

But on the plus side, I did learn how to save to a packaged workbook!

 

Spoiler
bjkay30_0-1593527287299.png

 

Highlighted
8 - Asteroid

My solution~