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

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
Quasar

Fun!

 

Spoiler
I went the way of the macro...


Capture.PNGCapture2.PNG
Comet

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

Pulsar

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

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

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

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,