In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
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
That was insanely fun. It reminded me of an Advent of Code puzzle, but without the crying. The Advanced part was an iterative macro that took 10 iterations to find all the numbers.
Spoiler
The Intermediate wasn't too bad because all the missing values were in the same square. I just saw which values I needed in each row and each column, and saw where the values were the same.
For the Advanced Part, I added handling for how each square needs to have the digits 1-9. That allowed me to do a Join Multiple to identify where the Row, Column, and Square each needed the same value. There was a little bit of hand waving to get rid of bad results, and then I looped it back through the macro until everything had a value.
For the Advanced Part, I added handling for how each square needs to have the digits 1-9. That allowed me to do a Join Multiple to identify where the Row, Column, and Square each needed the same value. There was a little bit of hand waving to get rid of bad results, and then I looped it back through the macro until everything had a value.
