break rows into columns-cross tab

Question

hi guys,

I have the below dummy input and below that my desired output. In the process I got lost in Cross-tab tool. can you please help me to get to where I want to be? attaching my workflow.

item      price

112233  2
112233 10
4556     1
4556     5
4556    10

___

item      price1  price 2    price3   total

112233   2            10                      12

4556       1             5           10        16

TIA!

MKM

cross tab1.yxmd

atcodedog05 · Accepted Answer

Hi @EtamSoko

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

jdunkerley79 · Accepted Answer

I would suggest:

Use a multi-row formula tool to create a field going "Price1", "Price2" for each row resetting for each item

Use a summarise tool to make the totals

Use a union to join the two sets

Then a cross-tab will do what you want

Sample attached.

grazitti_sapna · Accepted Answer

Hi @EtamSoko,

Here is my take on your problem.

I hope it helps.

vizAlter · Accepted Answer

Hi @EtamSoko — "CrossTab" tool can give you the Totals as well. Try this solution:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!