​​​​Ed Orlando​

Alteryx Weekly Challenge #78

Find the Best Housing Markets

​

https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037

​

​

As we all know, the housing market these days is going a bit crazy... we'd like to capture some census data on the value of new privately owned housing units in various metropolitan areas to see where the top 10 markets are YTD as of end of April (data lags about 2 months behind).

​

Our objective for this challenge is to capture Census data from the following URL: https://www.census.gov/construction/bps/txt/t3yv201704.txt

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

We will then need to parse the data into the columns identified in text input #2, then sort to find the top 10 new housing markets based on value. 

​

Data Set #1   

​

Data Set #2                                                                                                

Final Data Set Solution

Workflow with Detail

​

​

​