Hello,
I have a built a workflow that translates the incoming data set into almost what I need.
Input:
Store, Item, Quantity
Output:
Item, Store #1, Store #2, Store #3, Store #4.
QTY QTY QTY QTY
The final problem I am trying to solve is that my workflow enters a single qty value for each store so an item is duplicated twice. I need it to be formatted as if multiple stores have an item, they are both populated on a single line and in the right columns.
Thank you for your time,
Natalia
