Happy New Year, and welcome back to Weekly Challenge! Here's to another year of stretching our skills, exploring new tools and encouraging each other to be the best Alteryx-ers we can be!
Today is a day that so many of you have awaited: Challenge #100! Not only do you earn bragging rights for completing 100 Challenges but this Challenge also gets you another shiny badge to add to your collection! We have 8 Challengers who are neck and neck with 99 completed Challenges, with a couple more contenders not too far behind. Check out the updated Weekly Challenge Index to see the current standings. Ready to get started? We're off to the races!
After a very busy 2017, @Ned really needed to get away from it all. So, he did what any of us would do: he set up his tent in the farthest location from any road in the state of Colorado. But, now it’s 2018 and we’re all ready to get back to work on completing the newest course of Interactive Lessons, passing the Advanced Designer Certification exam and preparing for Inspire 2018. All of us…except for Ned. Where exactly is Ned? And how quickly can we find him? Well, that's what you need to figure out!
You are provided with two Input datasets: ColoradoRoads.yxdb, which contains spatial data of all the roads in Colorado, and Colorado.yxdb, the administrative boundary of the state. Using these two files, you need to not only find the location of Ned's tent (within 100 meters of the correct answer) but also locate him the fastest you possibly can. You'll notice that the start file for this Challenge does not include the solution! To check the accuracy of your solution, plug your final coordinates into the app called "HowCloseIsNed", which is attached to this post. Not within 100 meters of Ned's tent? Can’t find him within a few minutes? Optimize your process, and try again! Share your results for distance and run time when you post your solution.
Due to file size limitations, challenge_100_start_file.yxzp and HowCloseIsNed.yxwz can be downloaded here.
My method isn't fool proof, but I got within 100 meters of @Ned (even if it happened to be a happy accident!)
When @jdunkerley79 says its hard then you look up from your work and pay attention. Took a little while to work out the best method, but I left it and came back for a second go before bed. Runs in 2mins 4 seconds.
Congrats to @patrick_digan for being the first to get to 100 challenges!
I'm not sure how I managed to get an answer as towards the end I was just throwing tools onto the canvas and hoping for the best...anyway I'm done, it's late and I'm going to bed.