Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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 #65: Fulfilling Inventory Orders

Normster
8 - Asteroid

My solution worked out exactly as the solution.provided.  Rare instance.

 

 

SuchitK
6 - Meteoroid

Completed

JasonHu
8 - Asteroid
Spoiler
workflow.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I make simple formula.

Spoiler
I shipped the order when the total shipments did not exceed.

IF [Quantity]+[Row-1:Shipment]>[Inventory] THEN
[Row-1:Shipment]
ELSE
[Quantity]+[Row-1:Shipment]
ENDIF

AkimasaKajitani_1-1600656924029.png

 


 

LukaszKarpinski
8 - Asteroid

My solution attached.

 

Spoiler
Łukasz_0-1600696182830.png

 

Tony_Castillo
10 - Fireball

Quite a few nested conditionals required

Spoiler
TC_bot_0-1601310662857.png



WernerE
8 - Asteroid

Thanks

soroosj
8 - Asteroid
Spoiler
Done!
rajatsadan
8 - Asteroid

Great Challenge!! Could relate to situations in my work!

tochy
8 - Asteroid

tochy_0-1601833518662.png