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.
SOLVED

Splitting data from rows to columns

arkimp
8 - Asteroid

Hi,

 

I have a data like below ..

 

DatecountryAmt_1Amt_2
2022-07-01UK10002000
2022-07-01US30002000
2022-07-02UK500600
2022-07-02US4000500

 

I need the output like this.  How can we achieve this?.

 

DateUK_Amt_1US_Amt_1UK_Amt_2US_Amt_2 
2022-07-011000300020002000 
2022-07-025004000600500 
      
1 REPLY 1
DataNath
17 - Castor

Hey @arkimp, how's this? The workflow just Transposes the data and brings the country as well as original header into the data, so that they can be combined into the new header before being Cross-Tabbed back to the format you'd like:

 

DataNath_0-1660211223703.png

Labels