Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# 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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #179: Calculating Order Status

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.

16 - Nebula

My solution.

Spoiler
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
7 - Meteor

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

17 - Castor

Here's my not very concise solution:

Spoiler
16 - Nebula

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.

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
8 - Asteroid

My solution attached.

7 - Meteor

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

Spoiler
14 - Magnetar

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
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com