Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #78: Find the Best Housing Markets

Highlighted
8 - Asteroid
 
Highlighted
Alteryx Partner

That was a tough one! Web scraping/text parsing can be very tricky, so this was a good practice. It's also quite illuminating to see how others tackled this problem.

 

Spoiler
Capture.PNG
Highlighted
13 - Pulsar

Here is my solution 

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Took me a while to figure out the need for multi-row formulas but got there in the end

Highlighted
8 - Asteroid

Really struggling to learn regex but got through it..

Highlighted
Alteryx Partner
Spoiler
AWC78.PNG

Fun data cleaning challenge

Highlighted
8 - Asteroid
Welcome to the Weekly Challenge. Each week Alteryx post a use case where you can put your Alteryx skills to the test. You'll be able to share your answers an...
Alteryx Partner

My solution below. 

 

Spoiler
nataliamiteva_1-1581876435473.pngnataliamiteva_0-1581876421402.png

 

Highlighted
8 - Asteroid

Thanks JoeM.

Highlighted
7 - Meteor

Could have dynamically renamed columns and not sure a regex + multi row is the best way to deal with the split lines but it worked in the end.