Transpose Columns to Rows

[LuneLune]

Hello,

1) I changed my dataset in Excel from this:

2) to this(good result):

3)I tried the same thing in Alteryx but Transpose function gives the different result(all rows converted into two columns).

How I can get the same result as in the excel picture number(2).

Thanks for your help,
LuneLune

[atcodedog05]

Hi @LuneLune 

You might have to use crosstab after this. Can you provide me the sample input as excel file i can help you out.

[FlorianC]

Hi @LuneLune,

After transposing your columns to rows using the transpose tool, you can use the cross-tab tool to pivot the toy names to columns as can be seen in the sample workflow attached.

Workflow

[atcodedog05]

And Yup @FlorianC has the perfect solution workflow for it.

Hi @FlorianC 

Just curious, is there is a specific reason why you have chosen to share a packaged workflow instead of normal workflow. Just curious 🙂

[LuneLune]

Thanks Florian,

Can you just share a normal workflow instead of the packaged one?

Here is my original file.

[FlorianC]

Hi @atcodedog05,

Good question. I guess it is out of habit to ensure all dependencies are included. 😁

[atcodedog05]

-

[FlorianC · Accepted solution]

Hi @LuneLune,

Please find attached the raw sample workflow.

[atcodedog05]

Hi @LuneLune 

Here is a article which helps on how to tackle version issue. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-packaged-workflow-Fil...

So that you are equipped for next time🙂

[atcodedog05]

Hi @FlorianC 

Thats a great habit 🙂

Apparently is leads to version error issue. Which a lot of people dont know how to tackle 😅

Some pros and some cons😅