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.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.