community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

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

 

 

Asteroid
Spoiler
151.JPG
Alteryx
Alteryx

Hello,

 

Here is my solution !

 

 

Spoiler
Capture.JPG

 

 

Nebula
Nebula

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

Meteor

Good one and my first one :)

Asteroid
Spoiler
Weekly151.PNG
Comet

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Comet

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Atom
Spoiler
Capture.JPG

Boom!