community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
SOLVED

Challenge #135: Locker Problem

Meteoroid

Solution attached.

 

The field length in macro was creating errors...

Asteroid

Cheers!

Spoiler
I went with an iterative macro, and then plugged it back into my workflow. 
Challenge_135.png
Alteryx Partner

I love the generate row tool and the Iterative Macro!

 

Spoiler
1.PNG
2.PNG

 

Asteroid

Challenge Completed

Alteryx Certified Partner

I haven't built an Iterative Macro in a while :)

 

Spoiler
Challenge135.PNG
Asteroid

Here is my solution...

Aurora
Aurora

Solved this one 2 different ways - analytically using binary logic; and an iterator.

 

Spoiler

2018-11-18_11-27-16.png

 

Asteroid

This one was fun and quick! I feel like I'm really starting to get the hang of iterative macros.

 

Spoiler
Main workflow:
challenge_135_workflow.PNG

Macro:
challenge_135_macro.PNG




Alteryx Partner

My solution:

Spoiler
WF135_Solved.PNG135_Macro.PNG
Alteryx Certified Partner

Probably should have done this with a macro but it works anyway! :)