inventory sku substitution workflow logic needed

[corjuela]

I need to create a workflow that replaces my original SKU order with potential substitutions. The substitution skus can only be used at a first come first served bases(prioritizing store raking). Attached please an excel file showcasing my original order, how data is flowing and what the output should look like.

[ggruccioAYX]

Hi @corjuela,

What you have submitted reminds me of a weekly challenge, where an iterative macro is used to solve a challenge based on store priorities.   Please see if this aligns with your needs, or gives you an idea of how to go forward.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-14-Warehouse-Distribution/td-p/36743