Hi
I have a requirement to split a single row to multiple rows by selecting n columns for each row
In the example I am splitting the source data into multiple rows by selecting every 5 columns
Input
| Value 1 | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 | Value 7 | Value 8 | Value 9 | Value 10 | Value 11 | Value 12 | Value 13 | Value 14 | Value 15 | Value 16 | Value 17 | Value 18 | Value 19 | Value 20 | Value 21 | Value 22 | Value 23 | Value 24 | Value 25 |
Output
| Value 1 | Value 2 | Value 3 | Value 4 | Value 5 |
| Value 6 | Value 7 | Value 8 | Value 9 | Value 10 |
| Value 11 | Value 12 | Value 13 | Value 14 | Value 15 |
| Value 16 | Value 17 | Value 18 | Value 19 | Value 20 |
| Value 21 | Value 22 | Value 23 | Value 24 | Value 25 |
I tried with Dynamic select and setting Field Number between a range. It works for small data set
But for larger sets its con ideal.
Is there a way to do this dynamically using any tools in Alteryx
Thanks in Advance
