Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

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

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
16 - Nebula
16 - Nebula

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,