We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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