Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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.

SUBMIT YOUR IDEA

Challenge #179: Calculating Order Status

Htaneja2
7 - Meteor

just a try to have simple solution

abramer
6 - Meteoroid

My solution:

 

Spoiler
Spoiler:



clipboard_image_0.png
RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

kshashank03
7 - Meteor

Like any good Alteryx Challenge this was more complicated than it first seemed. As pointed out by previous posters, I believe that the answer provided is incorrect because Order 8 Line 12 is supposed to be marked as a complete line. Some things worth considering are that the shortest way I found to determine if any orders were incomplete were if they even existed in the Open Orders table, hence the summarization tool.

 

Spoiler
Weekly Challenge 179 Shashank.png
KenL
Alteryx
Alteryx

My solution:

 

Spoiler
clipboard_image_0.png
Ken L.

Customer Support Engineer
Alteryx, Inc.

wwatson
12 - Quasar

The way i designed it the fact that an order line exists in the open order means it is still open, if it is also in the shipped file then it is by definition a partial shipment.

Niklas
8 - Asteroid

My solution

shnbrb
7 - Meteor
Spoiler
179.PNG
Inactive User
Not applicable

🙂