Hi,
I'm hoping that this is a simple operation, but I can't find the right combination of tools in Alteryx to transform my data approriately...
I'm generating a "summary" table (containing ~90 short columns) by extracting data from a workflow containing pension benefits. This table is then entered into an Excel front end for downstream processing in another application.
I've managed to extact the records from the data and have reduced it to a table with ~ 90 unique rows in the form:
| Category | Tranch | incIndexTable |
| Cat10A | Post 88 Post 89 GMP | CPI_0_3 |
| Cat10B | Post 88 Post 89 GMP | Fixed_4 |
| Cat11 | Post 88 Post 89 GMP | RPI_0_5 |
| Cat11A | Post 88 Post 89 GMP | Fixed_4 |
| Cat11B | Post 88 Post 89 GMP | Fixed_4 |
| Cat11C | Post 88 Pre 89 GMP | Fixed_3 |
| Cat11D | Post 88 Pre 89 GMP | Fixed_3 |
However, I need to tranpose so that the rows become columns, i.e.:
| Category | Cat10A | Cat10B | Cat11 | Cat11A | Cat11B | Cat11C | Cat11D |
| Tranch | Post 88 Post 89 GMP | Post 88 Post 89 GMP | Post 88 Post 89 GMP | Post 88 Post 89 GMP | Post 88 Post 89 GMP | Post 88 Pre 89 GMP | Post 88 Pre 89 GMP |
| incIndexTable | CPI_0_3 | Fixed_4 | RPI_0_5 | Fixed_4 | Fixed_4 | Fixed_3 | Fixed_3 |
In Excel, I could do this by a simple Copy and Paste¦Transpose, so I'm certain there will be a simple way to do this in Alteryx too.
I've tried using the each of the Arrange, Transpose and Cross Tab tools, but can't see a way to configure any of them appropriately.
Thanks in advance.
