Alteryx Designer Discussions

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

How can I change the orientation of a row to a column showing sales in one row

8 - Asteroid

I need to transform the orientation of my data from displaying sales, units, margin by row into one single row.  Below is example.

 

HeadBanger_1-1605734637048.png

 

Need to look like this 

 

HeadBanger_2-1605735101244.png

 

 

Alteryx Certified Partner

Hey @HeadBanger !

 

You can use Crosstab tool from the transform group to do that job. 

marcusmontenegro_0-1605735305879.png

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @HeadBanger 

 

I would do the following,

1. Formula tool to concatenate Name and Target

2. Crosstab tool to get everything in a single row. No need for a group by any fields. Just have the header as your concatenated field and value as Value.

 

P

8 - Asteroid

Hi Philip,

 

You da man.  Thanks!  This worked.  I was missing that concat part for name and target.  

Labels