cancel
Showing results for 
Search instead for 
Did you mean: 
INSPIRE 2018 | Join us in Anaheim June 4-7th for classroom training! Classes are filling up fast -- Secure Your Product Training Sessions Now!
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.

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
edorlando07
Meteor

Challenge #78 has been conquered!  Slightly different solution.

LandonG
Asteroid

Solution attached.

PhilipMannering
Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_78 - Snip.PNGMy App
ggruccio
Fireball

Getting better with parsing all the time....

samN
Asteroid

regex for the win

jamielaird
Alteryx Certified Partner

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

 

Spoiler
solution_78.png
Natasha
Alteryx Certified Partner

Didn't build the app but practiced Regex

Spoiler
Screen Shot 2017-12-29 at 21.56.35.png
jasperlch
Asteroid

Solution attached.

JS420
Asteroid

Challenge Completed