Data Transposition

[anetal179]

Hi, 

I have a problem. 

I need to change the data layout to a database.

How to do it in Alteryx?

[danilang · Accepted solution]

Hi @anetal179 

Any time you have a "Human Readable" report like this with multi-line headers, you need to break the input into sections and deal with them separately.

The top branch deals with the 2 header rows, first assigning a record ID to split them and then transposing the values.  The Sales type values are filled in in the multi-row tool and then the 2 records are split in the filter.  The Sales and Month columns are joined on field name(F!, F2,etc) and the null row is removed.  Then generate a month number to use in sorting since sorting on month name puts Feb before Jan.  Join these transposed header rows to the transposed data rows, again on field name and sort the results.  After clean up, you get 

Dan