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
16 - Nebula
16 - Nebula
Spoiler
Perhaps I'm over-complicating this, but I went for the dynamic replace. You would have to do a little more work if you wanted to keep the field order the same.
Capture.PNG
Highlighted
8 - Asteroid

My solution..

 

Spoiler
Challenge_151_Spoiler.JPG
Highlighted
12 - Quasar
12 - Quasar

Figured out a method that is a bit ugly, but I like it and it works!

Highlighted
11 - Bolide

Cheers!

Spoiler
Challenge_151.PNG
Highlighted
8 - Asteroid

Dynamic data parsing

Highlighted
13 - Pulsar

Here is my solution. 

 

Spoiler
Challenge 151 Meta Parsing.PNG
Highlighted
Alteryx Partner

This one uses a variety of tools.

Highlighted
12 - Quasar
Spoiler
Challenge #151 macro.PNGChallenge #151.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed 

Highlighted
10 - Fireball

"Each week your boss gives you a new dataset to parse. Each week it comes with a different schema..." sounds like my life!  🙂

 

My solution:  

Spoiler

 

I used a recordID in case there were duplicate strings, and a recordID for fields to keep them in the original order.

151EW.PNG