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.

Challenge #35: Data Cleansing Practice

Meteor

Hello,

 

Attaching the solution here.

 

Thanks!

My solution file.

Asteroid

Solution attached

Highlighted
Alteryx Partner

I cannot figure out how we are getting rid of the NULLS in the final SBU Code scenario....?

Hi Syfer,

 

You're close.

 

I realigned your columns in the union join which returned the correct result.

 

Spoiler
syfer889fix.png

- Matt

Alteryx Certified Partner

Nice exercise!

Alteryx Certified Partner
 
Alteryx Certified Partner

Follow my solution file attached...

Asteroid

I think I've taken some around-the-houses approaches here. I've since looked at some of the solutions and seen cleaner ways of cleansing the data. I've left my first solutions in the attached file though :)

Quasar

uploading my solution....