The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
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. 😁