Formula to Format Data

[nwatzlaf2319]

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

[ChrisTX]

Can you post sample input data and expected data in a table format, Excel file, YXDB file, or data inside a workflow?

To include external files with a workflow, you'll need to post a YXZP (zip format) using Alteryx menu Options > Export Workflow.

The yxmd file you posted doesn't include the input data file "New_orders.xlsx"

Chris

[nwatzlaf2319]

So sorry! Please see the updated workflow below (the bottom portion). I just used some sample data in a text input file.

Thank you for your time,

Natalia

[binuacs · Accepted solution]

@nwatzlaf2319 are you looking for the below output?

[nwatzlaf2319]

This is perfect! Thank you so much!!!!

I always forget about that helpful tool. 

Thanks again!

Natalia