Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #1: Join to Range

longyanChen
8 - Asteroid

hi

jaeheehwang
7 - Meteor

Completed 

klippard001
6 - Meteoroid

Glad to be jumping back into challenges!

barxdavid99
5 - Atom

Wanted to start from the beginning. Great challenge!

Spoiler
Spoilerbarxdavid99_0-1668710809946.png
serranoX
Alteryx
Alteryx

Completed!

Archie_bos
8 - Asteroid

ch_1.png

BhanuTadepalli
5 - Atom

Attached my solution below 

dougbaron
8 - Asteroid
Spoiler
douglaspbaron_0-1669221397034.png

 

danblythe_RSM
8 - Asteroid
Spoiler
I seem to have done it backwards to the solution. Rather than expanding the reference table to include all post codes, I used a formula to add the ranges to the source data. The solutions method works way better if there was more data in the reference table.

This was pretty enjoyable for a 2am challenge, I think I will work my way through the rest of these challenges. 😁
Simon254
5 - Atom

Enjoyed the challenge and I know these will help me grow my skills. Here is my solution using the Generate Rows Tool.