0 ×

03_​ZIP_​Local_​vs_​remoteHTTP

Workflow

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
data blending local remote HTTP connection zipped compressed unzip zip
2007 flight data as HTTP:// 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\2008.csv.bz2) and a zipped file from aremote 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.Blog post available at https://www.knime.org/blog/local-ZIP-meets-remote-ZIP ... and yes! They blend. Airline dataset onstat-computing.orgdownload2007.bz2Unzip file2007.bz2delay ratioper carrier2007-2008calculatedelay ratioby carrierRead file2007.csvpath URI into flow variable2008.csvremove cancelled flightsUnzip file2008.bz2URI into aflow variableremovecancelled flightshttp:// path2007 ZIP file HTTP Connection Download Unzip Files JavaScriptBar Chart delay ratioby carrier File Reader Table Rowto Variable File Reader Row Filter Unzip Files Table Rowto Variable Concatenate Row Filter file URI asflow var String Input 2007 flight data as HTTP:// 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\2008.csv.bz2) and a zipped file from aremote 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.Blog post available at https://www.knime.org/blog/local-ZIP-meets-remote-ZIP ... and yes! They blend. Airline dataset onstat-computing.orgdownload2007.bz2Unzip file2007.bz2delay ratioper carrier2007-2008calculatedelay ratioby carrierRead file2007.csvpath URI into flow variable2008.csvremove cancelled flightsUnzip file2008.bz2URI into aflow variableremovecancelled flightshttp:// path2007 ZIP file HTTP Connection Download Unzip Files JavaScriptBar Chart delay ratioby carrier File Reader Table Rowto Variable File Reader Row Filter Unzip Files Table Rowto Variable Concatenate Row Filter file URI asflow var String Input

Download

Get this workflow from the following link: Download

Nodes

03_​ZIP_​Local_​vs_​remoteHTTP consists of the following 204 nodes(s):

Plugins

03_​ZIP_​Local_​vs_​remoteHTTP contains nodes provided by the following 13 plugin(s):