Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFinally 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:
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
Check out the video solution containing all 3 solutions here: https://www.dataprepsolutions.com/2020/01/alteryx-weekly-challenge-200-lets-build.html
Intermediate level solution
I finally was able to get back to this on the weekend and do the advanced part.
Advanced solution: