Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

column data to headers

Mina2021
8 - Asteroid

Hi,

 

I have date set and is there any way to make Column- channel's data as header. Is there any option to do it on interface?

 

Something look like  below-

 

Date        Code     Learning    RTC   Delima    RemoteRTC 
12/7/201111000910110

 

If anyone could help me would be helpful. 

6 REPLIES 6
messi007
15 - Aurora
15 - Aurora

@Mina2021,

 

Not sure I get what you need:

Based on this input:

 

messi007_0-1616084176172.png

 

Could you please tell what you expect to have?

It will help us to give you the expected output.

Regards

Mina2021
8 - Asteroid

Hi 

 

alpha_123_0-1616084547456.png

Need to convert the above table into below format  

alpha_123_1-1616084670169.png

 

and the Action column's values are given based on the diff channels.

 

 

 

 

messi007
15 - Aurora
15 - Aurora

@Mina2021,

 

The Excel file you attached is different of what you're showing.

Could you please share the data of the last screen shot.

 

Best Regards

 

Mina2021
8 - Asteroid

Apologies.

Here you go.

Luke_C
17 - Castor

@Mina2021 

 

It sounds like you just need a crosstab tool. This will let you choose the column that the headers should be sourced from, and which column the data under each header should come from. 

 

Luke_C_0-1616086438176.png

 

messi007
15 - Aurora
15 - Aurora

@Mina2021,

 

Here you go

messi007_0-1616088682117.png

 

Regards,

Labels