Icon

00_​KNIME_​Workshop_​basics

Compilation of examples for workshop purposes
Example Workflow for ETL Basics Operations based on KNIME official examplesBased on adult.csv and couple of KNIME examples: "02_StringManipulation_MathFormula_RuleEngine", "03_JoinConcatenate_Examples", "05_More_Row_Filter_Examples","07_Advanced_Usage_of_GroupBy_Node" and adjusted to training purposes. ref = full-timeReference Valuescalculate avg ageby sexjoin avg and count on sex and incomeReadingadult.csvNo aggregationmethodReplace "-" with "" in native countryRound up age to the nearest 10new column for work statussex vs incomeSaving as csv fileSaving as Excel fileconverting age to string(see values spec)converting back tonumbersfiltering full-timefiltering full-timein one stepexclude MISSING native-countryexclude age,sex, racesplitting employedand unemployedmerging into onetable againReference Valuesstring to datetransformationcalculate avg ageby sexjoin avg and count on sex and incomeranking hours & ageby sexsorting hoursper weekReading writtenExcel file ReferenceRow Filter Table Creator GroupBy Joiner File Reader GroupBy String Manipulation Math Formula Rule Engine Pivoting CSV Writer Excel SheetAppender (XLS) Number To String(deprecated) String To Number(deprecated) Row Filter Rule-basedRow Filter Row Filter Column Filter Rule-basedRow Splitter Concatenate Table Creator String to Date&Time GroupBy Joiner Rank Sorter Excel Reader (XLS) Example Workflow for ETL Basics Operations based on KNIME official examplesBased on adult.csv and couple of KNIME examples: "02_StringManipulation_MathFormula_RuleEngine", "03_JoinConcatenate_Examples", "05_More_Row_Filter_Examples","07_Advanced_Usage_of_GroupBy_Node" and adjusted to training purposes. ref = full-timeReference Valuescalculate avg ageby sexjoin avg and count on sex and incomeReadingadult.csvNo aggregationmethodReplace "-" with "" in native countryRound up age to the nearest 10new column for work statussex vs incomeSaving as csv fileSaving as Excel fileconverting age to string(see values spec)converting back tonumbersfiltering full-timefiltering full-timein one stepexclude MISSING native-countryexclude age,sex, racesplitting employedand unemployedmerging into onetable againReference Valuesstring to datetransformationcalculate avg ageby sexjoin avg and count on sex and incomeranking hours & ageby sexsorting hoursper weekReading writtenExcel file ReferenceRow Filter Table Creator GroupBy Joiner File Reader GroupBy String Manipulation Math Formula Rule Engine Pivoting CSV Writer Excel SheetAppender (XLS) Number To String(deprecated) String To Number(deprecated) Row Filter Rule-basedRow Filter Row Filter Column Filter Rule-basedRow Splitter Concatenate Table Creator String to Date&Time GroupBy Joiner Rank Sorter Excel Reader (XLS)

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: rosy
Created at: 2017-01-31
On NodePit since: 2019-10-30
Last update: 2024-04-18
Created with KNIME version: v4.0.2
Tags: ETLstring manipulationjoinconcatenatecsv readercsv writerfile readerfiltergroupbysorterpivotingrule engine

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

Try NodePit Runner!