community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #36: Data Cleansing Extract Authors

Asteroid

Easy with guide alongside; thanks for practice exercise!

Asteroid
Spoiler
challenge_36_solution_justindavis.PNG

I find it to be bad practice to leave a column blank rather than leaving it with nulls, so the cleansing step at the end seems a bit unnecessary in my view. Nonetheless, quick little one and I enjoyed it.

Asteroid
 
Meteoroid

My solution:

 

Spoiler
clipboard_image_0.pngclipboard_image_1.png
Asteroid

Not very clean, but it is dynamic. Thankful for the solution saying how many columns there would be, I would have spent some time figuring out 264 exact

Spoiler
ZHSOL.png

Nice challenge!

Very helpful for future practical use!

Meteor

Here's my attempt

Spoiler
CarlosCris_0-1572623467018.png

OpTECH D&A Solution

Spoiler
 
 
 
 
 

Ashleigh_-_13-1572623548651.png



 OpTECH D&A Solution

Atom
Spoiler
atasi_0-1572624968930.png