Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

mbogusz
コメット
スポイラ
2019-07-27 21_01_30-Greenshot.png
piotrzawistowski
アステロイド

My version with Summary tool.

MartinStraech
アステロイド

Used a similar approach to the solution provided. My solution seems simpler, but it's probably not quite as robust for edge cases if the input dataset was different. Starting to get a better feel for the multi-row formula tool.

 

スポイラ
SolutionClipping.PNG
Inactive User
適用対象外

Wow! This was a bit difficult.

 

Here's my solution

スポイラ
Joined datasets, sorted by SKU and Demand, Used a Multi Row to Calculate a Remaining field, flagged rows where remaining changes and filtered them. 
Cosmin_S
アステロイド

My solution: attached.

Thank you. 

JamesMA
Alteryx Alumni (Retired)

I parked this challenge when I first came across I found it very tricky.

 

Even months later, with a lot more Alteryx experience under my belt, I found it difficult!

 

スポイラ
James Marks Week 65.PNG
FRANCK_ROUQUETTE
アステロイド

Thank you for the exercise - I used imbricated iterative macro to solve - great case - attached my solution

CaraI
Alteryx
Alteryx
スポイラ
65 challenge.jpg
ConradW
アステロイド

65 - complete

RobertoEstrada
アステロイド

My solution is a little bit different that the posted one but we got the same results.