Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
My solution!
スポイラ
Key for me on this one was to save myself some unnecessary re-ordering by reversing the string at the beginning. Then splitting out the digits, ordering by ID, then deriving the ending column number and pivoting the columns.
Cheers!
NJ
SO much fun!
スポイラ
I used a few more tools, because I wanted it to be totally dynamic (able to handle numbers of any reasonable width, number of decimal places, etc.)
Of course, the tricky part is that the crosstab tool sorts columns alphabetically. I was expecting it to sort 1, 10, 11, 12, 2, 3, etc., so I went through the extra step of padding the column headers and then removing the padding later. However, I learned from @patrick_digan's solution that crosstab sorts the columns numerically if the field selected for the column header is a numeric type!
Of course, the tricky part is that the crosstab tool sorts columns alphabetically. I was expecting it to sort 1, 10, 11, 12, 2, 3, etc., so I went through the extra step of padding the column headers and then removing the padding later. However, I learned from @patrick_digan's solution that crosstab sorts the columns numerically if the field selected for the column header is a numeric type!
