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.

Transposing the horizontal values to vertical format

dunkindonut7777
8 - Asteroid

Hi I have a problem regarding my data. I want to transpose the other values in the data from horizontal to vertical. See sample below:

 

Original Data:

  222222343435555512222233333755555
UniqueNoDescriptionPurchasesAPVPPEInventorySmall PurchOffice Eqpt
1To purchase100-100400-400  
2To acquire200-200    
3To sell300-300  500-500

 

Expected Output:

UniqueNoDescriptionCodeAccount NameAmount
1To purchase22222Purchases100
  234343APV-100
  55555PPE400
  122222Inventory-400
2To acquire22222Purchases200
  234343APV-200
3To sell33333Small Purch500
  755555Office Eqpt-500

 

Basicaly, I want to transform the data that would check the transactions per Unique No. in which adding the Account Name and Amount columns that were presented horizontally in origin. Can you help me with this one please?

3 REPLIES 3
gabrielvilella
14 - Magnetar

Here is how you can do this.

gabrielvilella_0-1667789813291.png

 

dunkindonut7777
8 - Asteroid

hello thank you for this. How about the column "Code"?

WilliamCTX
6 - Meteoroid

One way of doing this.

WilliamCTX_1-1667796167681.png

 

 

Labels