Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #151: Meta Parsing

Highlighted
11 - Bolide

With columns and data in same order as desired output.  What's with all the z's in the data?

Spoiler

I added the record ID to beginning of column name to force the cross tab tool to order the columns correctly then removed record id from header in Dynamic Rename.
Replace(Substring([_CurrentField_],2,toNumber(Length([_CurrentField_])-2)),"_"," ")

clipboard_image_0.png


Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
Spoiler
clipboard_image_0.png
Highlighted
8 - Asteroid

I like your thinking @matyohan!

Spoiler
Needed to sort first in both the input solutions and output solutions in order for the Expect Equal tool to function right.  Otherwise, job done.Needed to sort first in both the input solutions and output solutions in order for the Expect Equal tool to function right. Otherwise, job done.
Highlighted
8 - Asteroid

Took me much longer than I expected. Can't wait to see other solutions to this problem!

Highlighted
13 - Pulsar
13 - Pulsar

Forgot to attach spoiler.  Adding so challenges completed tracks correctly.

Spoiler
Challenge 151.JPG

 

Highlighted
Alteryx Certified Partner

Fun challenge!

 

Spoiler
Challenge 151.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

perfect use case for a macro!

Spoiler
challenge 151 macro.pngchallenge 151.png
Highlighted
8 - Asteroid

I remember looking at this challenge when it was fresh and not really understanding the data set and just skipping it. Coming back to fill in the gaps of my weekly challenges I'm glad to have finally solved this (:

Spoiler
ZHSOL.png
Highlighted
8 - Asteroid