Icon

03_​ZIP_​Local_​vs_​remoteHTTP

Will they blend? Local vs. Remote ZIP File

This workflow accesses a zipped file from a local URL (knime://knime.workflow/data\2008.csv.bz2) and a zipped file from a remote URL (http://stat-computing.org/dataexpo/2009/2007.csv.bz2) via HTTP connection on the web. The two data sets contain data about US flights for 2007 (remote) and 2008 (local). Both files are zipped and need unzipping. ... and yes! They blend.

BLOG: Local vs. remote files. Will blending overcome the distance? https://www.knime.org/blog/Local-vs-Remote

2007 flight data as HTTPS:// Remote ZIP file 2008 flight data as Local ZIP File Will they blend? Local vs. Remote ZIP FileThis workflow accesses a zipped file from a local URL ( knime://knime.workflow/data\flights_december2008.csv.gz) and a zipped file from aremote URL (https://hub.knime.com/lada/spaces/Public/latest/flights_december2007.csv.gz) via HTTP connection on the web. The two datasets contain data about US flights for December 2007 (remote) and December 2008 (local). Both files are zipped and need unzipping.Blog post available at https://www.knime.org/blog/local-ZIP-meets-remote-ZIP ... and yes! They blend. downloadflights_december2007.csv.gzUnzip fileflights_december2007.csv.gzdelay ratioper carrier fordecember 2007and december 2008calculatedelay ratioby carrierRead fileflights_december2007.csvRead fileflights_december2008.csvremove cancelledflightsUnzip fileflights_december2008.csv.gzremovecancelledflightshttps:// path toflights_december2007ZIP filepath URI into flow variableURI into aflow variableAirline dataseton KNIME HubDownload Unzip Files Bar Chart delay ratioby carrier File Reader File Reader Row Filter Unzip Files Concatenate Row Filter file URI asflow var String Input Table Rowto Variable Table Rowto Variable HTTPS Connection 2007 flight data as HTTPS:// Remote ZIP file 2008 flight data as Local ZIP File Will they blend? Local vs. Remote ZIP FileThis workflow accesses a zipped file from a local URL ( knime://knime.workflow/data\flights_december2008.csv.gz) and a zipped file from aremote URL (https://hub.knime.com/lada/spaces/Public/latest/flights_december2007.csv.gz) via HTTP connection on the web. The two datasets contain data about US flights for December 2007 (remote) and December 2008 (local). Both files are zipped and need unzipping.Blog post available at https://www.knime.org/blog/local-ZIP-meets-remote-ZIP ... and yes! They blend. downloadflights_december2007.csv.gzUnzip fileflights_december2007.csv.gzdelay ratioper carrier fordecember 2007and december 2008calculatedelay ratioby carrierRead fileflights_december2007.csvRead fileflights_december2008.csvremove cancelledflightsUnzip fileflights_december2008.csv.gzremovecancelledflightshttps:// path toflights_december2007ZIP filepath URI into flow variableURI into aflow variableAirline dataseton KNIME HubDownload Unzip Files Bar Chart delay ratioby carrier File Reader File Reader Row Filter Unzip Files Concatenate Row Filter file URI asflow var String Input Table Rowto Variable Table Rowto Variable HTTPS Connection

Nodes

Extensions

Links