Challenge #151: Meta Parsing

[JoeM]

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]

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

Spoiler

[ddiesel]

Fun!

Spoiler

I went the way of the macro...

[T_Willins]

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

[EstherB47]

Ah, macros on a Monday afternoon 😉

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 

[Ladarthur]

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

[rfergus]

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

Spoiler

[RolandSchubert]

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

[Thableaus]

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

But, #151, done.

Spoiler

Cheers,