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
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 190 is done!

 

Spoiler
challenge 190 JMS solution.PNG
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Right down to the fake "[Null]"s for the three records that didn't join!

Capture.PNG

Highlighted
8 - Asteroid

My Solution!!

Highlighted
13 - Pulsar

Here is my workflow for this challenge. 

 

Spoiler
Workflow and answer.PNG
Highlighted
11 - Bolide

My solution

Highlighted
Alteryx
Alteryx

Niceeeee

Spoiler
Challenge_190_LG.PNG
Highlighted
8 - Asteroid

 

Spoiler
sprodger_0-1574181078864.png

 

 

Highlighted
Alteryx Partner

I think I've finally got a handle on Joins....

 

Spoiler
Spoiler
Process:
- Join data on PN
- Union left and join outputs
- Summary to calculate Total Prior APV (for calculating proportions)
- Sort by PN then by Prior APV (desc) to get order correct for Split field
- Join threads on PN
- Calculate proportion of each supplier against Prior APV
- Generate data for Split field
- Aggregate data and concatenate Split field (group by PN)
- Remove "," and "-" from Split + Ensure Null records as required
- Remove Proportion field

MySolution.PNG
Highlighted
8 - Asteroid

Fun challenge. This was the first time I had a use for using concatenate within the summary tool. 

Spoiler
ZHSOL.png
Highlighted
11 - Bolide
11 - Bolide
Spoiler
Challenge 190.PNG