We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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
14 - Magnetar

@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
13 - Pulsar

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