Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Table Transformation - How To Convert Columns in to the row along with heading

AnilC
6 - Meteoroid

Hello All,

 

Hope all of you are doing well

 

I have a table with 2 columns

 

AnilC_0-1685929042446.png

I want to transform it like

 

AnilC_2-1685929194302.png

 

 

I am not able to do it, kindly help me.

 

Thanks & Gratitude in advance  

5 REPLIES 5
geraldo
13 - Pulsar

@AnilC 

 



an example workflow. but the column name is value and the contents can be sorted however you wan

Yoshiro_Fujimori
15 - Aurora

@AnilC ,

One way of doing this. (There may be better ways.)

Workflow

Yoshiro_Fujimori_0-1685934831135.png

 

AnilC
6 - Meteoroid

Hi @Yoshiro_Fujimori Thanks a lot, it will help

AnilC
6 - Meteoroid

Hello @geraldo Thanks a lot, it will help.

flying008
15 - Aurora

Hi, @AnilC 

 

Another way for dynamic solution. [If you have multiple fields and the field names are disorder.]

 

录制_2023_06_05_12_23_06_835.gif

Labels