Challenge #65: Fulfilling Inventory Orders
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mbogusz
9 - Comet
07-27-2019
06:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
piotrzawistowski
8 - Asteroid
07-28-2019
12:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
MartinStraech
8 - Asteroid
07-30-2019
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.

Inactive User
Not applicable
08-02-2019
03:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
08-08-2019
04:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JamesMA
Alteryx Alumni (Retired)
08-11-2019
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
FRANCK_ROUQUETTE
8 - Asteroid
08-21-2019
02:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
08-22-2019
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ConradW
8 - Asteroid
08-23-2019
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RobertoEstrada
8 - Asteroid
08-23-2019
11:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator