Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #151: Meta Parsing

JoeS
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_AYX  in creating this years back!

 

Spoiler
Workflow.png

 

 

KevinW
8 - Asteroid
Spoiler
151.JPG
itestu
Alteryx
Alteryx

Hello,

 

Here is my solution !

 

 

Spoiler
Capture.JPG

 

 

danilang
19 - Altair
19 - Altair

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

PadmajaS
7 - Meteor

Good one and my first one :)

Number4
8 - Asteroid
Spoiler
Weekly151.PNG
cgoodman3
14 - Magnetar
14 - Magnetar

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
cgoodman3
14 - Magnetar
14 - Magnetar

Too many tools compared to other solutions posted.

 

Spoiler
Challenge 151.JPG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
358802
5 - Atom
Spoiler
Capture.JPG
AndrewSharot
5 - Atom

Boom!