Transpose/Crosstab Function

Hi All,

I do not have much experience using the transpose and cross tab tools in Alteryx; now I need to in order to apply a formula. I have a feeling this will be a cake-walk for someone...

Rather than typing it all out, essentially, this is what my data looks like:

And this is what I need it to look like:

Transformation

Preparation

Accepted answers

CharlieS

Hi @Tessa

This can be done with the CrossTab tool. Set the "Group" parameter to "Products", "Headers" to "Year", "Values" to "Qty", and "Method" to "First".

Check out the attached workflow for an example of this in action.

20200228-CrossTab.yxmd

All comments

estherb47

Hi @Tessa

Try a crosstab tool. For any fields you want as row headers on the left, put those in the Group by function (In your example, Products. Otherwise, that's optional)

For column headers here, you want the year field. And the values should be Qty.

You can use any summary function. Let me know if that helps!!

Cheers,

Esther

CharlieS

Hi @Tessa

This can be done with the CrossTab tool. Set the "Group" parameter to "Products", "Headers" to "Year", "Values" to "Qty", and "Method" to "First".

Check out the attached workflow for an example of this in action.

20200228-CrossTab.yxmd

Tessa

Worked like a charm Charlie! Thank you!

(I love that about the Alteryx community- I just knew I could get a quick answer 🙂 )

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703