Icon

Sample solution to PreppinData 2021 Week 1

#PreppinData - 2021 Week 1Sample solution with custom visualization Read dataCount bikesBikes fromRowID to columnUpper: with mistakesLower: without mistakesGenerate numeric ID for each bikeCorrect spellingmistakes basedon Lookup-TableAggregate bysumming bike valuesGroup by quarter and day of the month,pivot by bike names,aggregateby computing the mean of bike valuesSave manipulated table Excel Reader Cell Splitter Extract Date&TimeFields Row Filter Table Manipulator Value Counter RowID Row Splitter Counter Generation Similarity Search Joiner Cell Replacer Group Loop Start Moving Aggregation Loop End Pivoting Excel Writer Visualize BikeRunning Totals #PreppinData - 2021 Week 1Sample solution with custom visualization Read dataCount bikesBikes fromRowID to columnUpper: with mistakesLower: without mistakesGenerate numeric ID for each bikeCorrect spellingmistakes basedon Lookup-TableAggregate bysumming bike valuesGroup by quarter and day of the month,pivot by bike names,aggregateby computing the mean of bike valuesSave manipulated table Excel Reader Cell Splitter Extract Date&TimeFields Row Filter Table Manipulator Value Counter RowID Row Splitter Counter Generation Similarity Search Joiner Cell Replacer Group Loop Start Moving Aggregation Loop End Pivoting Excel Writer Visualize BikeRunning Totals

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: roberto.cadili
Created at: 2021-10-22
On NodePit since: 2021-10-22
Last update: 2024-04-27
Created with KNIME version: v4.4.2

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

Try NodePit Runner!