Icon

20210623 Aggregation Granularity

There has been no description set for this workflow's metadata.

Read users input of the date&time column, value column, and the timegranularity Extract date&time components from the date&time column. Based on the selected time granularity, an aggregated date&time will becreated (except for Quarter and Week). Perform aggregation based on selected granularity. At the end, a constant column is appended that contains theGranularity information. extract alldatetime componentstake only thetimestampand value colsperform aggregationcreate theaggregated timestampadd thegranularity colfail if datetimeand granularitynot compatibletop: anything elsemiddle: Quarterbottom: Weekdetermine the portsfor the Case Switch nodeperform aggregation quarterlyperform aggregation weeklymapping ofgranularities &queries for theString Manipulation nodecheck if the selected datetime column supports the selected granularitycheck if the selected value column supports the selected granularityfail if value column typeand aggregationnot compatibleselect timestampselect aggregation columnselect granularityselect aggregationmethodmerge allflow variablesNode 378AggregationGranularity Extract Date&TimeFields Column Filter GroupBy String Manipulation ConstantValue Column Breakpoint CASE SwitchData (Start) CASE SwitchData (End) Rule EngineVariable GroupBy GroupBy Table Creator Error check Get granularityand the mapping Create a new aggregateddatetime column Error check Breakpoint Column SelectionConfiguration Column SelectionConfiguration Single SelectionConfiguration Single SelectionConfiguration Column Rename(Regex) Column Rename(Regex) Merge Variables(deprecated) Merge Variables(deprecated) Read users input of the date&time column, value column, and the timegranularity Extract date&time components from the date&time column. Based on the selected time granularity, an aggregated date&time will becreated (except for Quarter and Week). Perform aggregation based on selected granularity. At the end, a constant column is appended that contains theGranularity information. extract alldatetime componentstake only thetimestampand value colsperform aggregationcreate theaggregated timestampadd thegranularity colfail if datetimeand granularitynot compatibletop: anything elsemiddle: Quarterbottom: Weekdetermine the portsfor the Case Switch nodeperform aggregation quarterlyperform aggregation weeklymapping ofgranularities &queries for theString Manipulation nodecheck if the selected datetime column supports the selected granularitycheck if the selected value column supports the selected granularityfail if value column typeand aggregationnot compatibleselect timestampselect aggregation columnselect granularityselect aggregationmethodmerge allflow variablesNode 378AggregationGranularity Extract Date&TimeFields Column Filter GroupBy String Manipulation ConstantValue Column Breakpoint CASE SwitchData (Start) CASE SwitchData (End) Rule EngineVariable GroupBy GroupBy Table Creator Error check Get granularityand the mapping Create a new aggregateddatetime column Error check Breakpoint Column SelectionConfiguration Column SelectionConfiguration Single SelectionConfiguration Single SelectionConfiguration Column Rename(Regex) Column Rename(Regex) Merge Variables(deprecated) Merge Variables(deprecated)

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: Molina
Created at: 2021-06-23
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.2.4

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

Try NodePit Runner!