topic Re: column data to headers in Alteryx Designer Desktop Discussions

column data to headers

Mina2021 — Thu, 18 Mar 2021 16:06:42 GMT

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/2011	1100091	0	1	1	0

If anyone could help me would be helpful.

Re: column data to headers

messi007 — Thu, 18 Mar 2021 16:17:38 GMT

@Mina2021,

Not sure I get what you need:

Based on this input:

Could you please tell what you expect to have?

It will help us to give you the expected output.

Regards

Re: column data to headers

Mina2021 — Thu, 18 Mar 2021 16:31:10 GMT

Hi messi007,

Need to convert the above table into below format

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

Re: column data to headers

messi007 — Thu, 18 Mar 2021 16:39:22 GMT

@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

Re: column data to headers

Mina2021 — Thu, 18 Mar 2021 16:53:10 GMT

Apologies.

Here you go.

Re: column data to headers

Luke_C — Thu, 18 Mar 2021 16:55:08 GMT

@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.

Re: column data to headers

messi007 — Thu, 18 Mar 2021 17:36:47 GMT

@Mina2021,

Here you go

Regards,