Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
8 - Asteroid

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

Spoiler
RobbieA_0-1672961439350.pngRobbieA_1-1672961491978.png

 

 

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

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1675420119219.png

love a brute force solve 

kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_239_KU.png
alexnajm
18 - Pollux
18 - Pollux

Difficult

bjkay30
8 - Asteroid

My solution.

 

Spoiler
bjkay30_0-1682629509902.png

 

alacoume
9 - Comet

A solution:

leonhekkert
8 - Asteroid

Brute force for me I'm afraid:

 

Spoiler
Challenge_239.png
mithily
8 - Asteroid
Spoiler
brute force followed the data to its logical conclusion
tristank
11 - Bolide

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

 

Spoiler
Screenshot 2023-08-12 131317.png

 

ed_hayter
13 - Pulsar
Spoiler
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.