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

Convert field value to column names

vshekharrc
7 - Meteor

Hi team,

 

I am trying to convert values of a field as columns. Please see attached. My current table is Table 1. I want it in the format shown in Table 2. Could you please help me how I can achieve this in alteryx. I am not getting my head straight around this with transpose option.

 

Thanks,

Varun

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

Hi @vshekharrc 

 

You could use a crosstab tool for this. Transpose would do the opposite. I suggest taking a look at some of the trainings in the academy, there's some really great content there on this.

 

https://help.alteryx.com/current/designer/cross-tab-tool

 

 

Luke_C_0-1624470481248.png

 

vshekharrc
7 - Meteor

Hi Luke_C,

 

Thank you for helping me on this. Yes, I am already onto the link that you have sent to learn more about it. Good day to you 🙂

 

Regards,

Varun

Labels
Top Solution Authors