Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAEntered for the London Grand Prix prelims and decided to time myself taking 9min 41sec. Took too long trying to solve a part where I need a unique tool but looking at others solutions others didn't need it so will review those to understand the differences, and blown away that @NicoleJohnson did it in sub-4!
EDIT: Worked out it's because I take the matched fields from for the right input on of the join which caused the data to duplicate and then needing unique to de-duplicate. The data duplication is what cost me the time there!
6 minutes of work
Tough one to crack, it took me a while to find the right tool so probaly wouldn't have made the cut in the Grand Prix. Still very fun though!
First time using any sort of spatial tool, so it was a bit of trial and error, and a couple of tool searches, but I figured it out!
Great!