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 #179: Calculating Order Status

Highlighted
8 - Asteroid
Spoiler
Spoiler

clipboard_image_0.png
Highlighted
Alteryx Certified Partner

My solution

Highlighted
8 - Asteroid

My Solution:

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution!

Highlighted
14 - Magnetar
14 - Magnetar

The logic was challenging to wrap my head around, but this worked in any case!


Highlighted
Alteryx Partner

My Solution

Highlighted
11 - Bolide

My solution is pretty similar to a lot of the others.

 

A couple of hints, if you were confused about the requirements like I was!

Spoiler
1 - The output should only contain lines that have something shipped
2 - The Qty in the output should be the order quantity if nothing has shipped, or the shipped quantity if something has shipped.
3 - If something exists in the Open Orders table, then the line status is Partial (even if the shipment quantity matches). I'm not sure how it's possible to have an order qty of 1 and a shipped qty of 1 and still be open, but that's how it appears to work! In other words, if a line exists at all in Open Orders, then it is not totally fulfilled yet.

My workflow:

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Honestly had a hard time understanding the description (seems I'm not the only one!) but ended up getting there.

 

Spoiler
challenge_179_solution_justindavis.PNG
Highlighted
Alteryx Certified Partner

My solution

 

Spoiler
challenge_179.PNG
Highlighted
Alteryx Certified Partner

Solution attached

Spoiler
Screenshot 2019-09-30 at 14.07.16.png