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
Solved! Go to Solution.
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.
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.
Hi @atcodedog05,
Good question. I guess it is out of habit to ensure all dependencies are included. 😁
-
Hi @LuneLune,
Please find attached the raw sample workflow.
Hi @LuneLune
Here is a article which helps on how to tackle version issue.
So that you are equipped for next time🙂
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😅