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
Alteryx
Alteryx

Perfect use case for the Crew Macro - Dynamic Formula.

 

A lot more efficient than other ways, especially if we were to be playing with more than 100 rows of data.

 

Also keeps the field order as well.

 

Take a look into the macro - it's modifying the XML, kudos to @AdamR  in creating this years back!

 

Spoiler
Workflow.png

 

 

Highlighted
8 - Asteroid
Spoiler
151.JPG
Highlighted
Alteryx
Alteryx

Hello,

 

Here is my solution !

 

 

Spoiler
Capture.JPG

 

 

Highlighted
17 - Castor
17 - Castor

Nice challenge.  Tricky getting the output column order correct.

 

Spoiler
I went the transpose-join route as opposed to using an append fields/formula combo 

I got the column order correct by using the Data dictionary record ID as the key in the Cross tab.  These get sorted into the proper order then it's a dynamic rename

solution.png

 

Dan

Highlighted
7 - Meteor

Good one and my first one 🙂

Highlighted
8 - Asteroid
Spoiler
Weekly151.PNG
Highlighted
11 - Bolide
11 - Bolide

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Highlighted
11 - Bolide
11 - Bolide

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Highlighted
5 - Atom
Spoiler
Capture.JPG
Highlighted
5 - Atom

Boom!