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

Director, Customer Enablement
Director, Customer Enablement

Each week your boss gives you a new dataset to parse. Each week it comes with a different schema and an accompanying dataset with how it should be parsed. Create a process that automatically parses the data from the data dictionary. Once created, you should be able to simply replicate your process for the 'B' dataset by copying and pasting. 

Meteoroid

Might be more dynamic ways to solve this, but it worked

 

Spoiler
challenge151.png
Highlighted
Quasar

Fun!

 

Spoiler
I went the way of the macro...


Capture.PNGCapture2.PNG
Quasar

Need to change this to a macro to make it more dynamic.

Magnetar
Magnetar

Ah, macros on a Monday afternoon ;)

image.png

 

 

Spoiler
To make it as dynamic as possible, and to have the order of the columns reflect the order in the data dictionary, I used a column order field in the cross tab tool, and a dynamic rename to put the text back in the headers. Otherwise my solution looks very much like @ahal and @ddiesel 

image.png
Quasar
Quasar

Fun one! did the workflow first and then changed to a macro :)

Alteryx Partner

Took a little while to figure out a method to keep the column order from the data dictionary

 

Spoiler
image.png
Alteryx Certified Partner
Alteryx Certified Partner

My solution - started with a workflow, but switched to macro then

Alteryx Certified Partner
Alteryx Certified Partner
 
Alteryx Certified Partner
Alteryx Certified Partner

It demanded a bit of thought to order the columns exactly as they should be.

But, #151, done.

Spoiler
Challenge151.PNG

Cheers,