Challenge #78: Find the Best Housing Markets

[JBevan89]

Great Challenge

[Will_Condon]

Went to town on this one. Bonuses all around!. App for selecting Value vs Units, sort on field, even quantity of list.  Great exercise for working with unstructured data.  Prepping for Advanced Cert.

Several spoilers.  First the workflow.

Spoiler

 

Interface:

Spoiler

 

Result:

Spoiler

 

Workflow Processes:

Spoiler

Workflow Process

Download URLs, save as text files. (Container to disable.)
Create two workflow streams: Units and Values selected using Radio Button (Bonus and Bonus).
Containers disabled based on user application interface
Options to report based on Housing $ Value or Unit Quantity.
User options to sort list on any quantity field and depth of list (Defaults to Total field and top 10).

Stream 1: Top n Areas (Value/Units
Text Input downloaded URLs with filename field.
Convert URL text to structured table:
Assign Record ID for control.
Calculate length of each row to detect anomalies (rather than search for embedded CRLF).
Strip out header and footer rows (requires designer intervention each time file changes).
Use Multi-Row tool to reconstruct spit rows due to embedded CRLF.
Filter full rows, drop partial rows.
RegEx parse tool to create eight fields:
(\d+)\s+(\d+)\s+([A-Za-z ,\-\*]+)\s+(\d+)\s+(\d+)\s+(\d+)\s+(\d+)\s+(\d+)
Trim padded spaces from Name to avoid warnings.
Revise format to conform with solution.
Sort descending on Total (Drop Down - Bonus).
Sample Size (Numeric Up Down - More Bonus?).
On Value workflow the Multi-Field tool is used to add $ to the value.
Create Report object

Stream 2: Data As Of Date
Unique record based on filename.
Formula to create Data As Of and report type.
Select only As Of field
Create report object

Union report objects from the two streams
Report Layout
Render Report as temporary PDF.

[robert-headington]

Here is my solution for 78