Hi All
I am struggling on Alteryx about my data set.
I start from this situation with all data organized on the rows 1 and 2
I would need an output like this (so basically every seven columns the other seven columns should be put above as a raw)
do you have a specific solution/workflow for that? i try transpose tool but no results on this topic. I attached my input and the output i should have from alteryx
Danilo
@Danilo9017 hi, tough one for me as well, but I managed to get to the desired solution:)
Please take a look at what I have came up with - it involves iterative macro and a number of other tools.
@Danilo9017 another way of doing this
1. you need to transpose the data
2. group the data into 7 records with the tiles tool
3. cross tab the records
4. again group the data into 3 records for sorting purpose
5. sort the records based on the new tiles number
6. output to xlsx by checking the property Skip field names
@binuacs great solution - simple and effective! I did not realize the full potential of the tile tool:)