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
I get the same info but the columns are not in the same order, but I cannot find any rhyme or reason to the column order of the answer. I suppose I could manipulate the order of the answer, but that seems pointless (and kind of like cheating)
Spoiler
Process:
- Concatenate Category, Subcategory, and Description (allowing for nulls in the Subcategory)
- Transpose data in lower thread
- Join data
- Sort results by Name (not needed but part of my heroically feeble attempt to match the answer column order
- Cross-tab back
- Dynamic rename (since cross-tab seems to add underscores) to replace Header
- Remove unneeded column
- Concatenate Category, Subcategory, and Description (allowing for nulls in the Subcategory)
- Transpose data in lower thread
- Join data
- Sort results by Name (not needed but part of my heroically feeble attempt to match the answer column order
- Cross-tab back
- Dynamic rename (since cross-tab seems to add underscores) to replace Header
- Remove unneeded column
Welcome to the Weekly Challenge. Each week Alteryx post a use case where you can put your Alteryx skills to the test. You'll be able to share your answers and collaborate with other challengers to arrive at an answer. Participation will be rewarded - just make sure you are attaching your Alteryx ...
