This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackEach 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.
Ah, macros on a Monday afternoon 😉
Took a little while to figure out a method to keep the column order from the data dictionary
It demanded a bit of thought to order the columns exactly as they should be.
But, #151, done.
Cheers,