Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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.
SOLVED

Challenge #135: Locker Problem

Highlighted
7 - Meteor

Solution attached.

 

The field length in macro was creating errors...

Highlighted
11 - Bolide

Cheers!

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

I love the generate row tool and the Iterative Macro!

 

Spoiler
1.PNG
2.PNG

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Highlighted
Alteryx Certified Partner

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

 

Spoiler
Challenge135.PNG
Highlighted
8 - Asteroid

Here is my solution...

Highlighted
16 - Nebula
16 - Nebula

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

 

Spoiler

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

 

Highlighted
11 - Bolide

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




Highlighted
Alteryx Partner

My solution:

Spoiler
WF135_Solved.PNG135_Macro.PNG
Highlighted
Alteryx Certified Partner

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