How to transpose table?

[mestevez1]

Hi,

I've been trying to transpose a table that would be very simple to do in Excel, but I can't seem to find how to translate to Alteryx.

My original table looks like this:

Date	License Type 1	License Type 2	Total Licenses
12/31/2018	301340	96033	397373
1/31/2019	315762	91827	407589

I want to get to the following:

Date	12/31/2018	1/31/2019
License Type 1	301340	315762
License Type 2	96033	91827
Total Licenses	397373	407589

I eventually want to calculate the delta between each date to check if license use has grow or shrink:

Date	12/31/2018	1/31/2019	New Licenses
License Type 1	301340	315762	14422
License Type 2	96033	91827	-4206
Total Licenses	397373	407589	10216

The yxmd file is attached for reference.

Thanks for the help,

Mauricio

[Thableaus · Accepted solution]

Hi @mestevez1 

You'll probably need a transpose tool and then a Cross-Tab to get this done.

Notice that the Dates are not ordered and also slashes were replaced by underscores.

This happens when you use the Cross-Tab tool. It replaces any non-alphanumeric character to a underscore.

Also, it orders the columns alphabetically. If you want to keep them in the exact order, you need a workaround.

Cheers,

[mestevez1]

Hi @Thableaus ,

Thanks for the lightning fast solution! This solution is perfect.

Cheers,

Mauricio

[owenkosnen]

And do you mind elaborating more on the workaround? I am not able to reorder the row with Select tool after the crosstab.