Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
16 - Nebula

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