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

RobbieA
Asteroide

Started a macro but got lost, brute forced instead. Ended up with 25 results if you include leading 0's, 1 result without.

Saqueador
RobbieA_0-1672961439350.pngRobbieA_1-1672961491978.png

 

 

Had split to my appends up with filters for duplicate letters to prevent laptop exploding. 

FinnCharlton
Pulsar
Saqueador
FinnCharlton_0-1675420119219.png

love a brute force solve 

kristiadiuisan
Asteroide
Saqueador
Alteryx_challenge_239_KU.png
alexnajm
19 - Altair
19 - Altair

Difficult

bjkay30
Asteroide

My solution.

 

Saqueador
bjkay30_0-1682629509902.png

 

alacoume
Cometa

A solution:

leonhekkert
Asteroide

Brute force for me I'm afraid:

 

Saqueador
Challenge_239.png
mithily
Asteroide
Saqueador
brute force followed the data to its logical conclusion
tristank
Bólide

I know as soon as I see the two tool solutions I'm gonna rip my hair out.

 

Saqueador
Screenshot 2023-08-12 131317.png

 

ed_hayter
Pulsar
Saqueador
Spent a long time a few weeks ago looking at algorithmically trying to solve this with no luck. Next I looked into bruteforcing and my logic was sound but I did not want to wait around explode the data and contract and set up each individual filter correctly.

Turned to the R tool and a bit of help from ChatGPT to write a script that did what I wanted in terms of generating all combinations testing them and returning correct solutions then used a find and replace to get the output.

image.png

Edit R-Tool section of the flow took 8 minutes to run - for people who want to write more efficient code.