Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

TRANSPOSE THE VALUES FROM HORIZONTAL TO VERTICAL POSITIONING

dunkindonut7777
8 - Asteroid

Hi I have a data here that has sum of debits and credits per id code. I want to spread out the values vertically.

 

Raw data:

IDCodePeriodDebitCredit
100011                               50                100
100012                            100                200
100013                            300                400
100021                            500                300
100022                            300                200
100023                            300                400

 

Expected Output:

 

                       1                     2                  3
IDCODESum of DebitSum of CreditSum of DebitSum of CreditSum of DebitSum of Credit
10001                   50                            100                100                 200                 300          400
10002                 500                            300                300                 200                 300          400

 

I want to group it by period and presented the sum of debit and credit. Can you help me with this one pls?

6 REPLIES 6
DataNath
17 - Castor

How does this look @dunkindonut7777? Did you mean to drop the 'Period' field?

 

DataNath_0-1656660780838.png

 

grazitti_sapna
17 - Castor

Hi @dunkindonut7777, there is another way to solve this problem.

grazitti_sapna_0-1656661301955.png

 

Thanks!

Sapna Gupta
flying008
14 - Magnetar

Hi, @dunkindonut7777 

 

Just do this !

 

录制_2022_07_01_15_43_20_650.gif

binuacs
20 - Arcturus

@dunkindonut7777 one way of doing this

binuacs_0-1656663836525.png

 

binuacs
20 - Arcturus

@dunkindonut7777 Another way of doing this with the same column names for both Debit and Credit fields

binuacs_0-1656664608288.png

 

camie
6 - Meteoroid

@dunkindonut7777

you can also check the attached if it fits your requirement. 

Labels