Last week's solution can be found HERE!
This week's challenge was brought to us by one of our own Community members and Weekly Challenge gurus: @NicoleJohnson. Nicole devised this challenge for her user group whilst looking for a challenge that would exercise many of the commonly used tools in Alteryx. If you ever have a challenge that you would like to be featured, please DM me!
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.
BONUS:
Build an app that will allow you to choose whether you want to look at value (the "v" in "t3yv" in the URL above) or units (which would look like "t3yu"), specify the through-date (year & month designated at the end of the txt file name, in the example above as "201704"), and which column you want to sort by (Total, 1 Unit, 2 Units, etc.)
This location will be one of the top performing markets
