We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #239: SEND + MORE = MONEY

5 - Atom

Good One. Used a brute force solution.

8 - Asteroid
Spoiler
Eh
15 - Aurora

I tried to come up with a solution which was as dynamic as possible and I think I managed to achieve just that.

I spent quite some time wondering why I was getting 25 potential solutions instead of 1, until thankfully I read @dsmdavid comment who also faced the same issue.

On the downside, I had to make a compromise on runtime since for example if words are formed from 8 distinct letters that can take 10 unique values, there are 10^8 different combinations that can occur.

Workflow

Spoiler

Iterative Macro

Spoiler

12 - Quasar

This solution will work only for this problem not for general problems.

Spoiler

13 - Pulsar

Brute force as the macro was taking too long to run.

Spoiler

9 - Comet

Wow, interested challenge! Thanks

Spoiler
I used Brute Force and batch macro to solve it. It takes 1h40m lol =))
Definetly not a good way
17 - Castor

This is brutal..

Spoiler
12 - Quasar
Spoiler
15 - Aurora
Spoiler
Definitely could be a little more dynamic but this works

14 - Magnetar

Well this one was a doozy.

Spoiler
My main goal in this one was to make it flexible (to allow for other verbal arithmetic problems that might vary in length) and to not just throw 71098 tools on the canvas. Both objectives were... challenging. But I'm pleased with the final result!

The general approach I took was to create all the combinations of 8 numbers between 0-9 (since there are only 8 unique letters in the problem), and then use a sweet RegEx approach I developed years ago where you build the RegEx find string and replace string based on the data (allowing for flexibility of length and pattern of letters). Fun to come full circle and re-use something I built for work almost 3 years ago!! If interested in the original use case for dynamic RegEx building, check out A Particularly Problematic Parsing Example example in Use Cases 🙂

Ended up with an iterative macro in this one too, which always gives me that warm & fuzzy feeling... 🙂

Iterates through the combinations of numbers by generating 10 rows of data every time, for numbers 0-9, and then filtering out any values that have already appeared in the combination. Concatenates the new value on to the end of the original combo string, then iterates through again until you reach the desired number of numbers (i.e. unique letters in your problem).

Cheers!

NJ