community
cancel
Showing results for 
Search instead for 
Did you mean: 

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 #151: Meta Parsing

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
Fireball

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Highlighted
Fireball

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Atom
Spoiler
Capture.JPG

Boom!