Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #239: SEND + MORE = MONEY

danicahui
8 - Asteroid
Spoiler
Challenge 239 2020-11-19.jpg
JoshuaGostick
11 - Bolide

Split the words out to speed up time.

 

Spoiler
challenge_239.PNG
rmassambane
10 - Fireball

I have to confess that I brute forced it.

robert-headington
8 - Asteroid

When I use Alteryx, one of the philosophies I go by is to try and make everything as repeatable and reusable as possible. After all, why just solve today's problem when you can solve future problems at the same time.

 

With that in mind I wanted to create a macro that doesn't just solve SEND + MORE = MONEY (with each letter being a different number between 0 and 9) but also any other equation like this.

 

While I did this, this is a rare example where this approach doesn't really work. The macro I created does work for any solution, however on longer equations it takes so long that it really isn't feasible to use for them (like the one in the example would take weeks to run). I'm still going to submit the macro as it is a solution and the macro contains the logic to solve it in a quicker time.

quenhu
7 - Meteor

Is there anyone trying Optimization tool ?

 

Spoiler
Workflow
quenhu_0-1615268201924.png

 

 

 

Luke_C
17 - Castor
17 - Castor

Luke_C_0-1617462446140.png

 

rcarog
8 - Asteroid

Solution attached.

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission, fun challenge!

estherb47
15 - Aurora
15 - Aurora

Enjoyed this one!

 

Spoiler
estherb47_0-1638288043426.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 239.png