Weekly Challenges

nicoleserrafero · ‎01-31-2020

Finally got intermediate done! Going to see if logic works for the Advanced one if i modify my macro a bit.

Screenshots below could figure out how to upload workflow/macro if it doesn't count!

Workflow:

Spoiler

Step 1: flip to grid

Step 2: Get all row and column values

Step 3: Input into Iterative macro

Step 4: Macro will loop until number is not found in either the column or row

This bottom part logic will have to change for the advanced one as it works if i loop 9x, seems to mess up if more than 9.

Step 5: Check against the intermediate solution:

L Mine R solution

Step 1: flip to gridStep 2: Get all row and column valuesStep 3: Input into Iterative macro Step 4: Macro will loop until number is not found in either the column or rowThis bottom part logic will have to change for the advanced one as it works if i loop 9x, seems to mess up if more than 9. Step 5: Check against the intermediate solution:L Mine R solution

JennyMartin · ‎01-31-2020

Spoiler

Check out the video solution containing all 3 solutions here: https://www.dataprepsolutions.com/2020/01/alteryx-weekly-challenge-200-lets-build.html

PaulRB · ‎01-31-2020

Intermediate level solution

Spoiler

Victor_Mendes · ‎01-31-2020

Solved, for any sudoku input!

Begginer + Intermediate

Spoiler

Advanced

Spoiler

Input and Solution

Macro

hbraunius · ‎01-31-2020

Following up with my advanced solution.

Spoiler

atcodedog05 · ‎02-01-2020

Just started.

This is my first weekly challenge. Really exited 🙂

I was able to solve beginner and intermediate challenge.

Beginner

Spoiler

Intermediate

Spoiler

Really enjoyed it.

kat · ‎02-01-2020

Yay - 200!

Beginner

Spoiler

Intermediate

Spoiler

Advanced

Spoiler

The advanced version will work as long as no trial and error is needed 🙂

TonyA · ‎02-02-2020

I finally was able to get back to this on the weekend and do the advanced part.

Spoiler

I used an iterative macro similar to some of the other solutions. I'm going to try this on a number of advanced puzzles, I'm pretty sure that this relatively simple iterative elimination solution is going to run into problems on some of those since most of the code solutions I've seen use backtracking.

I have an additional output that shows the grid with any remaining candidates for unsolved cells to see where this algorithm falls over (if it does).

Edit: I just tested this with a sudoku rated as very hard and it failed to solve it. I added that sudoku to the workflow as a separate test input not connected to the workflow.

I used an iterative macro similar to some of the other solutions. I'm going to try this on a number of advanced puzzles, I'm pretty sure that this relatively simple iterative elimination solution is going to run into problems on some of those since most of the code solutions I've seen use backtracking.I have an additional output that shows the grid with any remaining candidates for unsolved cells to see where this algorithm falls over (if it does).Edit: I just tested this with a sudoku rated as very hard and it failed to solve it. I added that sudoku to the workflow as a separate test input not connected to the workflow.

afv2688 · ‎02-03-2020

Beginner and intermediate 🙂

Spoiler

PaulRB · ‎02-03-2020

Advanced solution:

Spoiler

Weekly Challenges

IDEAS WANTED

Challenge #200: Sudoku Solver