In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

From Vertical axis to horizontal axis

JannicB
5 - Atom

Hello Alteryx Community.

I have an issue I don't manage to solve on alteryx.

 

I would like to switch lines to columns via an excel sheet and I don't know how to do that.

Please find attached an excel sheet with my request.

 

I thought that I can use pivot table button

 

 

6 REPLIES 6
afv2688
16 - Nebula
16 - Nebula

Hello @JannicB ,

 

You can do this for sure using the crosstab tool.

 

Untitled.png

 

there is no data attached, if you share it with us I could do maybe help you

 

Regards

JannicB
5 - Atom

alteryx 1.JPGThe Antivius scan doesn't accept the file, so here are a print screen.

Thanks a lot

 
afv2688
16 - Nebula
16 - Nebula

Hello @JannicB ,

 

Is this ok?

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

JannicB
5 - Atom

Thanks a lot @afv2688

It works now!

 

Do you know if it's possible to have multiple values in vertical axis?

like for example value & volume:

 

Year | Product | gender | age | W1 Value | W2 Value | … | W1 Volume | W2 Volume |....

2019 | GLOVE | MALE | adult | 10            | 20            | …  | 2                 | 4                  | ...

2020 | GLOVE | MALE | adult | 7              | 3              | …  | 1                 | 3                  | ...

afv2688
16 - Nebula
16 - Nebula

Hello @JannicB,

 

You could add another transpose and merge both with a join tool:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

JannicB
5 - Atom

amazing!!

Thanks a lot for your support.

it will change my alteryx life!

thanks again.

Best,

Jannic

Labels
Top Solution Authors