0 ×

00_​KNIME_​Workshop_​basics

Workflow

Compilation of examples for workshop purposes
ETLstring manipulationjoinconcatenatecsv readercsv writerfile readerfiltergroupbysorterpivotingrule engine
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)

Download

Get this workflow from the following link: Download

Nodes

00_​KNIME_​Workshop_​basics consists of the following 27 nodes(s):

Plugins

00_​KNIME_​Workshop_​basics contains nodes provided by the following 5 plugin(s):