Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #190: Supply Chain Management Challenge

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

Challenge 190.PNG
Highlighted
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
Asteroid
Spoiler
190_solution.png

Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
Bolide
Bolide

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