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
Start Free Trial

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

Solution to the Challenge #1

Brian32
8 - Asteroid

Solution to the Challenge

charliegorman
6 - Meteoroid

First weekly challenge ✔️

tirpower
5 - Atom

Cool, 

 

Didn't think of using a Tile tool immediately - chose an Append tool (which if this list were larger, then it probably wouldn't be a sustainable tool to use) coupled with a Formula to designate postal codes in a given range, then Filtered to keep the correct ones, finally joining on the range.

 

Formula expression:

 

IIF(ToNumber([Postal Area]) >= ToNumber(Left([Range], 4))
AND
ToNumber([Postal Area]) <= ToNumber(Right([Range], 4)),
1, 0
)

sgreenough
8 - Asteroid

Solved!

RobertMika
7 - Meteor

Done

Tommy_Alterax
8 - Asteroid

Heres my solution guys - just starting out - Believe it or not never had to use the Generate rows tool so was pretty impressed with it :)

mackenzie_short
8 - Asteroid

first weekly challenge! starting from the bottom

MilindG
12 - Quasar
Spoiler
MilindG_0-1658334312397.png

 

alexandreandrade
5 - Atom

Here is my answer