Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.