Icon

04_​AmazonS3-MSBlobStorage_​Census_​Data

Will They Blend? Amazon S3 meets MS Blob Storage plus Excel
This workflow blends together data from three different sources: Amazon S3 and Azure Blob Store from the cloud and Microsoft Excel from a localfile. From Excel In Maine women whospeak no English have theshortest commute. Shouldyou stop learning English? But then again the numberof women who speak noEnglish in this dataset isonly 31. Keep learningEnglish. New File Handling Framework ENG vs.SEX_textmean(Travel Time)& COUNTavg travel timevs. English proficiencyby sexMISSING -> 99ENG & SEXJWMNP as"Travel Timeto Work"remove rowswith missing ENGvalueremove COUNTMale& Femaleby ascendingENGremove meanMale& FemaleCOUNTvs. English proficiencyby sexprovide the working directoryon MS Azure Blob StorageConnect toMS AzureBlob Storagereadinginto KNIME:people in MaineSEX_MapValuesENG_MapValuesConnect to Amazon S3provide the working directoryon Amazon S3readinginto KNIME:homes in Mainejoin on SERIAL NOjoin on SERIAL NOjoin on ENG Pivoting Bar Chart Missing Value Column Rename Row Filter Column Filter Column Rename Sorter Column Filter Column Rename Bar Chart Azure Blob StorageConnector MicrosoftAuthentication CSV Reader Excel Reader Excel Reader AmazonAuthentication Amazon S3 Connector CSV Reader Joiner Joiner Joiner This workflow blends together data from three different sources: Amazon S3 and Azure Blob Store from the cloud and Microsoft Excel from a localfile. From Excel In Maine women whospeak no English have theshortest commute. Shouldyou stop learning English? But then again the numberof women who speak noEnglish in this dataset isonly 31. Keep learningEnglish. New File Handling Framework ENG vs.SEX_textmean(Travel Time)& COUNTavg travel timevs. English proficiencyby sexMISSING -> 99ENG & SEXJWMNP as"Travel Timeto Work"remove rowswith missing ENGvalueremove COUNTMale& Femaleby ascendingENGremove meanMale& FemaleCOUNTvs. English proficiencyby sexprovide the working directoryon MS Azure Blob StorageConnect toMS AzureBlob Storagereadinginto KNIME:people in MaineSEX_MapValuesENG_MapValuesConnect to Amazon S3provide the working directoryon Amazon S3readinginto KNIME:homes in Mainejoin on SERIAL NOjoin on SERIAL NOjoin on ENG Pivoting Bar Chart Missing Value Column Rename Row Filter Column Filter Column Rename Sorter Column Filter Column Rename Bar Chart Azure Blob StorageConnector MicrosoftAuthentication CSV Reader Excel Reader Excel Reader AmazonAuthentication Amazon S3 Connector CSV Reader Joiner Joiner Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: glandrum
Created at: 2017-01-09
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v4.5.1
Tags: data blendingS3MicrosoftBlobStorageCloud servicecloudKNIME connectorsAmazonWill they blend

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!