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 #190: Supply Chain Management Challenge

Highlighted
8 - Asteroid
 
Highlighted
6 - Meteoroid
 
Highlighted
Alteryx
Alteryx
Spoiler
My solution as pictured below and attached.

Challenge 190.PNG
Highlighted
8 - Asteroid

Here's my attempt at this.  After I did this, I realized that I could have concatenated the splits with a sum tool instead of the crosstab/transpose combo, and could have eliminated 4 or 5 extra tools.

 

Spoiler
bjkay30_0-1574779708702.png
Highlighted
Alteryx Partner

complete

Highlighted
Alteryx Partner
Spoiler
190.PNG
Highlighted
11 - Bolide
Spoiler
190_solution.png

Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
12 - Quasar
12 - Quasar

Had to manually insert the text "[Null]" to get an exact match.

Highlighted
Alteryx Certified Partner

Okay, it has been a while, so this was a nice challenge to get back in the saddle 😉

 

Spoiler
So here it is, kind of messy, but in the end, I did get to match the result
My Messy WorkflowMy Messy Workflow

 

There was one thing that seemed really odd to me, and that was the field [Total Prior APV] that in the provided result was not Null, but saved as a string with the value "[Null]". I simply do not know why you would do that, but in order to match the result 100% I added the weird function

Still climbing
/Verakso