cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps
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 #78: Find the Best Housing Markets

Aurora
Aurora

Thanks for the challenge @NicoleJohnson

 

Spoiler

Took a different approach than most others - instead of taking the file into a string and then parsing, I just dumped it into a temp file, and then used the "Fixed Width File" option which takes care of the variable length of the rows by putting in nulls.

Then just had to do a bit of cleanup for the row overruns, and job done.

2017-10-08_20-25-08.png


Highlighted
Meteor

Challenge #78 has been conquered!  Slightly different solution.

Asteroid

Solution attached.

Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_78 - Snip.PNGMy App
Bolide
Bolide

Getting better with parsing all the time....

Comet

regex for the win

Alteryx Certified Partner

Solution attached, including a catch for the pesky newline issue.

 

Spoiler
solution_78.png
Alteryx Certified Partner

Didn't build the app but practiced Regex

Spoiler
Screen Shot 2017-12-29 at 21.56.35.png
Bolide

Solution attached.

Asteroid

Challenge Completed