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.

Weekly Challenge Index & Welcome

Highlighted
Alteryx Community Team
Alteryx Community Team

THIS IS AWESOME!!

 

@alexh , @mceleavey  love the collaboration and creativity!

 

@cplewis90 - I should run an analysis on who had the steepest ascent, you'd be right up there!

 

@kelly_gilbert love the annotations! Congrats on cracking the leader board!

Highlighted
12 - Quasar
12 - Quasar

@JoeM That would be a great analysis! Maybe next to the leaderboard we add a fastest riser leaderboard :D

Highlighted
12 - Quasar
12 - Quasar

@Alekh @mceleavey,

 

I am a little confused and there may be some slight differences. I haven't dug in enough yet to see, but your two trackers show I have completed two different amounts of challenges. @Alekh - 141, @mceleavey -142. The difference is around Challenge 120 where I only posted a spoiler tag and picture and forgot to attach the workflow. I put it in spoiler for this just in case.

Spoiler
challenge 120 solution.PNG
Highlighted
12 - Quasar
12 - Quasar

I think I know why there is a problem @Alekh@mceleavey. For some reason I decided to change the subject line for my Challenge #120 post to just say "Chris Lewis - Solution" removing the challenge # from it so the parse does not have a way of knowing which challenge it is. Not sure how @mceleavey did it. Looking at another challenge where I completed I noticed the differences.

comparison.PNG

Highlighted
Alteryx Partner

Haha, what a very unique scenario. Had me worried that I'd have to redo a lot of the workflow. Still, it's important that I have a 100% accurate output regardless of the user. I'm lucky it was an easy fix. You made me think about it slightly differently. Instead of searching for challenge numbers, I use the end of the URLs of each challenge to get the thread ID and search for that instead. E.g. the end of the URL for challenge #120  (https://community.alteryx.com/t5/Weekly-Challenge/Challenge-120-Popular-Baby-Names/td-p/171607) is 171607 which is the thread ID. Searching specifically for the thread ID tag within a user's post history within the HTML provides practically an infallible method now (don't wanna jinx it though!). All the regex now use a very robust parse so I don't think there'd be any issues from now on.

 

The difference between mine and @mceleavey is that mceleavey is searching for any instance of a response by you in a challenge thread. In 99% of cases it'd be good enough. But there are cases where a user may post in a challenge thread without posting a solution. So basically my workflow will search specifically for any instances for a spoiler, attachment or image.

 

Thanks for the find. I've attached the updated version. 

Highlighted
14 - Magnetar
14 - Magnetar

Love this, @Alekh , and honored to be the test user!!

 

 

Highlighted
8 - Asteroid

HI,

 

Do we need to complete all the challenged and upload here?

Highlighted
13 - Pulsar

Hi @jyotijyoti,

 

You reply back to each challenge separately as you complete them.  For example, at the beginning of the thread for Challenge 1 is an explanation for Challenge 1 as well as the start file.  After completing Challenge 1, reply back the post that started Challenge 1 and attach your workflow with your Challenge 1 solution. 

 

Have fun and happy Alteryxing!

Highlighted
Alteryx Partner

Oops, was just let known that I let a few extra column pass through in the final output. Got rid of them. Can't edit my previous reply so making a new one. 

Highlighted
7 - Meteor

Hi! I just learned about the Weekly Challenges last week at Inspire 2019 so I'm really new to this. It looks like when everyone completes a challenge they just reply to the challenge and upload their solution... Is this correct?