Weekly Challenge

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

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

Submit Feedback
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.

Challenge #200: Sudoku Solver

Highlighted
8 - Asteroid

My solutions for Beginner and Intermediate:

Highlighted
11 - Bolide

Solution attached

Highlighted
17 - Castor
17 - Castor

Beginner and Intermediate.  Now if only I could solve them in my head, like Lord Vetinari.

200px-Lord_Vetinari.jpg

 

Spoiler
w.png

Dan

Highlighted
Alteryx Partner
Spoiler
Beginner and Intermediate Solutions200.PNG
Highlighted
Alteryx Partner

All set on the advanced solution. I put my iterative macro/data cleansing in a standard macro to keep the canvas clean. Fun challenge! 

Spoiler
Top LevelTop Level


standard macro.png


Iterative macro gutsIterative macro guts


Highlighted
5 - Atom

Beginner Level,

 

Spoiler
salima_0-1580228718656.png
Highlighted
Alteryx Certified Partner

Here my solution Beginner and Intermediate.

 

Beginner

Spoiler
carlosteixeira2005_0-1580231871709.png

Intermediate

 

Spoiler
carlosteixeira2005_1-1580231918117.png
Highlighted
8 - Asteroid

I completed the beginner solution yesterday; here is the intermediate one today. Fun challenge. The basic idea is to add 45 on all rows and columns; this would ensure that the numbers 1-9 are only being used once per box.

 

First generate the possible solutions by row or record ID; then find the unique number not already used on other solutions and plug it in.

 

By the way, I was blown away with the macros and R snippets solving the advanced one; I always enjoy looking at your workflows.

Spoiler
2020-01-28_11-30-30.jpg
Highlighted
Alteryx Partner

Beginner and Intermediate solutions attached

Spoiler
JustinBabbittEAG_0-1580243070128.png
Macro: 
JustinBabbittEAG_1-1580243134688.png
8 - Asteroid

I built a solver for the advanced challenge, and used it for the intermediate. But more importantly: I built a working macro!! 

Spoiler
sonyakasenkramer_0-1580247623035.pngsonyakasenkramer_1-1580247637920.png