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
9 - Comet
Spoiler
2019-07-27 21_01_30-Greenshot.png
piotrzawistowski
8 - Asteroid

My version with Summary tool.

MartinStraech
8 - Asteroid

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.

 

Spoiler
SolutionClipping.PNG
Inactive User
Not applicable

Wow! This was a bit difficult.

 

Here's my solution

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

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!

 

Spoiler
James Marks Week 65.PNG
FRANCK_ROUQUETTE
8 - Asteroid

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

CaraI
Alteryx
Alteryx
Spoiler
65 challenge.jpg
ConradW
8 - Asteroid

65 - complete

RobertoEstrada
8 - Asteroid

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