Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #64: Catch Me If You Can

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1575985358809.png
Highlighted
8 - Asteroid
Spoiler
Challenge 64 2019-12-23.jpg
Highlighted
Alteryx Partner

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


MySolution.PNG
Highlighted
8 - Asteroid
 
Alteryx
Alteryx

Solution attached

Highlighted
8 - Asteroid
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 an...
Highlighted
Alteryx Partner
Spoiler
AWC64.png

Enjoyed the challenge of getting dynamic rename to do what I wanted!

Highlighted
8 - Asteroid
 
Highlighted
Alteryx Partner
Spoiler
Blake_0-1582045329069.png

 

KISS!