Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #151: Meta Parsing

Highlighted
Alteryx Community Team
Alteryx Community Team

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. 

Highlighted
6 - Meteoroid

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

 

Spoiler
challenge151.png
Highlighted
12 - Quasar

Fun!

 

Spoiler
I went the way of the macro...


Capture.PNGCapture2.PNG
Highlighted
13 - Pulsar

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

Highlighted
14 - Magnetar
14 - 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
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
Alteryx Partner

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

 

Spoiler
image.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
 
Highlighted
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,