Accessing compressed data on the web inside Alteryx
The following post was written by Joseph Lombardi, an intern working with the Alteryx Advanced Analytics team.
OverviewAs with any real-world data source, nothing is perfect. Things can be dynamic, unsorted, or even encrypted, so it is useful to have the tools and skills to work around these issues. Alteryx comes in handy, as it gives its users the customization and data modification tools to make this problem-solving go a lot quicker.
There are three main topics covered:Automating the download of multiple filesUnzipping compressed dataFormatting the data to be read correctly into Alteryx
The real world example used to address these can be found here: http://thedataweb.rm.census.gov/ftp/cps_ftp.html