In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Substitution logic using Alteryx

corjuela
5 - Atom

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

 

  1. Column A through C are the QTY needed (example Store AAA; 6 Cars, 4 Chairs, 6 Desks)
  2. Column D through F are the potential substitutions
  3. Column G is my optimal solution, orders that I need to place to the factory after exhausting all my potential substitutions. 
  4. Repeat for next Store

Thank you for your help.

 

1 REPLY 1
Christina_H
14 - Magnetar

Try this

Christina_Hurrell_0-1635864338691.png

 

Labels
Top Solution Authors