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.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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

Challenge #151: Meta Parsing

JoeM
Alteryx Alumni (Retired)

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
14 - Magnetar
14 - Magnetar

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

estherb47
15 - Aurora
15 - Aurora

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
Ladarthure
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,