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

DavidThorpe
Alteryx
Alteryx

My solution:

Original_Yodies
8 - Asteroid

Probably not the most elegant or efficient, but here is my solution.

Looking forward to seeing what others of you have done now!

Spoiler
clipboard_image_0.png
wdavis
Alteryx
Alteryx

Took me a while to understand which shipments were completed. The best use of the 3 join outputs!

Reesetrain2
9 - Comet

All,

 

An interesting challenge as it too me a bit to realize that this one was two parts:

Spoiler
The first part was to Sum the open order numbers and get the status of the Open order and combine those two pieces of information later in the workflow.

-I used Join and Union twice and the coded the results in an Active order via the Formula Tool.

Capture.PNG

-Cheers!

Matt

kyseq
7 - Meteor

My solution is attached. I really thought I could do the bulk of the work with multi-formula tool, but I just couldn't make it work any better than the standard tool. I feel multi-formula is really powerful, but I can't quite get a grasp it. So I just used a combination of the standard formula tools and the summarize tool to make it work.

NicholasM
Alteryx Alumni (Retired)

Took me longer than I care to admit!

jarontb
5 - Atom
Spoiler
clipboard_image_1.png
jduracka
Alteryx
Alteryx

Here is my solution

Spoiler
clipboard_image_1.png
LordNeilLord
15 - Aurora

Not sure I got this one entirely but I managed to get the right answer

 

Spoiler
Capture.PNG
ZenonH
8 - Asteroid

My order 8 line 12 was broken, like others mentioned, but otherwise good (:

I got confused at one point with different fields having the same name and had to restart.

Spoiler
ZHWF.PNG