SOLVED
Substitution logic using Alteryx
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
corjuela
5 - Atom
‎11-02-2021
06:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
My problem: I need to order some qty from the factory, but before I do that, I have some items in storage that could be potential substitutions (ranked: best, good, decent).
Below please find a simple version of what I want to accomplish using an Alteryx workflow
- Column A through C are the QTY needed (example Store AAA; 6 Cars, 4 Chairs, 6 Desks)
- Column D through F are the potential substitutions
- Column G is my optimal solution, orders that I need to place to the factory after exhausting all my potential substitutions.
- Repeat for next Store
Thank you for your help.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
1 REPLY 1
Christina_H
14 - Magnetar
‎11-02-2021
07:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
