community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Transpose table

Atom

Hello, how can I transpose this in Alteryx?

 

This is how I want it to be:

Year

2009

20102011201320142015
ID#123456789101121443
CountryUSAUKMXFRJPCN
Price

$5

66666
Cost

$2

33333
Profit

$3

33333

 

This is what I have in Alteryx now, how can I transpose it to be like the table above?

YearID#CountryPriceCostProfit
2009123

US

533
2010456UK633
2011789CN633
2013121JP633
20141234RR633
201512345MX633
Alteryx Certified Partner
Alteryx Certified Partner

Hi @mfang 

 

Here's a solution:

Snip.PNG

 

- Transpose grouping by Year

- Cross-Tab values grouping by Name field generated

- Select Tool to rename Name field by Year

 

 

WF attached.

Cheers,

Atom

Thanks @Thableaus!

 

How can I arrange the rows such as the country, ID comes after the year just as my example shows? 

 

Year2016 
CountryUSA 
ID2533J 
Price6 
Cost3 
Profit3 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @mfang 

 

I use Tile Tool to organize rows and sort them in order.

 

Snip.PNG

 

See flow attached.

 

Cheers,

Labels