Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
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

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here

 

This week's challenge comes to us from @wwatson!  Based on a use case, this challenge recreates a real-life business problem (calculating order status) that was solved with Alteryx.

 

Thanks @wwatson for submitting this challenge! 

 

Have a great idea for a challenge?  We want to hear it!  Submit your challenge idea to our Academy Team to contribute to our Community.  

 

 

RolandSchubert
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
03-09-_2019_18-41-44.png
acastelazo
8 - Asteroid

There might be an error with order #8 line #12. The solution has it marked as "Partial" for the "Line Complete Status," but I argue that line is in fact complete. Just because a line is in the "Open Orders" file doesn't mean that line is partially shipped. It just means that line belongs to an order that is still open. Therefore, you have to check the shipped quantities against the ordered quantities to check the status of each line.

Spoiler
Capture.JPG
andresleonm
7 - Meteor

I was about to say that. It has to say "Order Complete Status" -> "Partial" and "Line Complete Status" -> "Line Complete".

patrick_digan
16 - Nebula
16 - Nebula

Here's my not very concise solution:

Spoiler
Annotation 2019-09-03 140808.jpg
RolandSchubert
15 - Aurora
15 - Aurora

I think, "Open Orders" lists the remaining (not yet delivered) quantity, so a line "8|12|2,H,1" in "Shipments" will be needed to fulfill the order line.

cplewis90
13 - Pulsar
13 - Pulsar

This was a tough one as I was able to figure out the Order Complete Status relatively quickly, but the Line Complete Status was tough and had some tricky parts. Overall fun challenge! I look forward to seeing how others finish this one. 

Spoiler
Challenge 179.PNG
hbraunius
8 - Asteroid

My solution attached.

andresleonm
7 - Meteor

Here is my solution. Please fix the challenge output in "Order Number" -> 8 "Line Number" -> 12.

 

Spoiler
clipboard_image_0.png
cgoodman3
12 - Quasar
12 - Quasar

I spend longer than I'd like to admit solving this as I didn't understand why "8|12,H,1" isn't complete / complete, but worked out in the end how to get it to match the solution.

 

Spoiler
Challenge 179.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com