Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
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

JoeM
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. 

ahal
6 - Meteoroid

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

 

Spoiler
challenge151.png
ddiesel
12 - Quasar

Fun!

 

Spoiler
I went the way of the macro...


Capture.PNGCapture2.PNG
T_Willins
13 - Pulsar
13 - Pulsar

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

EstherB47
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
Ladarthur
13 - Pulsar
13 - Pulsar

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

rfergus
8 - Asteroid

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

 

Spoiler
image.png
RolandSchubert
15 - Aurora
15 - Aurora

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

CharlieS
17 - Castor
17 - Castor
 
Thableaus
17 - Castor
17 - Castor

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

But, #151, done.

Spoiler
Challenge151.PNG

Cheers,