Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
14 - Magnetar

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