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