Icon

05_​Select_​most_​recent_​date_​and_​time_​cells

Time filtering on the webportal

We here demonstrate how a date/time column can be filtered to contain only the last k month or week or days. On the webportal you chose the granularity and the number of those granularity you want to include in your analysis. Afterwards we filter them using the time difference (set to the selected granularity) and the rowfilter on the time difference value limited by the selected number of.
One example would be that we want to include the last 4 weeks of data since today. Than we would set the granularity to Week and the Number to four. The last page in the webportal show the minimum and maximum date after the filtering.

We here demonstrate how a date/time column can be filtered to contain only the last k month or week ordays. On the webportal you chose the granularity and the number of those granularity you want to includein your analysis. Afterwards we filter them using the time difference (set to the selected granularity) andthe rowfilter on the time difference value limited by the selected number of.One example would be that we want to include the last 4 weeks of data since today. Than we would setthe granularity to Week and the Number to four. The last page in the webportal show the minimum andmaximum date after the filtering. The logic of components is hidden in their inside. To open, right-click and select in the context menu" Component" -> Open Node 7Node 10Node 12Node 14 Select variables on webportalfor granularity and range View min/max date Create Date&TimeRange Date&Time-basedRow Filter We here demonstrate how a date/time column can be filtered to contain only the last k month or week ordays. On the webportal you chose the granularity and the number of those granularity you want to includein your analysis. Afterwards we filter them using the time difference (set to the selected granularity) andthe rowfilter on the time difference value limited by the selected number of.One example would be that we want to include the last 4 weeks of data since today. Than we would setthe granularity to Week and the Number to four. The last page in the webportal show the minimum andmaximum date after the filtering. The logic of components is hidden in their inside. To open, right-click and select in the context menu" Component" -> Open Node 7Node 10Node 12Node 14Select variables on webportalfor granularity and range View min/max date Create Date&TimeRange Date&Time-basedRow Filter

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: iris.adae
Created at: 2016-02-18
On NodePit since: 2019-07-12
Last update: 2024-04-26
Created with KNIME version: v4.1.0
Tags: WebPortalWidget

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

Try NodePit Runner!