Icon

KNIME_​filter_​date_​condition

Takes some data and a condition row
then determines if the date in the data is contained within the date range in the condition row, and that the another column matches the condition row too.

Cross joins and tests the condition to split the output

Workflow created as example for

https://forum.knime.com/t/pick-up-data-which-is-applicable-to-condition/32133

14 Apri 2021 @takbb Brian Bates

Takes some data and a condition rowthen determines if the date in the data is contained within the date range in the condition row, and that the anothercolumn matches the condition row too.Cross joins and tests the condition to split the outputWorkflow created as example for https://forum.knime.com/t/pick-up-data-which-is-applicable-to-condition/32133 DateStringsToDatesMaterial, Material_DateDataDivided into columnsConditionDivided into columnsAppend conditioncols to each rowMaterial, ToDate, FromDateDateStringsToDatesSelect the matchesSplit betweenthose that matchand those that don't String to Date&Time Column Rename Table Creator Cell Splitter Table Creator Cell Splitter Cross Joiner Column Rename String to Date&Time Rule Engine Row Splitter Takes some data and a condition rowthen determines if the date in the data is contained within the date range in the condition row, and that the anothercolumn matches the condition row too.Cross joins and tests the condition to split the outputWorkflow created as example for https://forum.knime.com/t/pick-up-data-which-is-applicable-to-condition/32133 DateStringsToDatesMaterial, Material_DateDataDivided into columnsConditionDivided into columnsAppend conditioncols to each rowMaterial, ToDate, FromDateDateStringsToDatesSelect the matchesSplit betweenthose that matchand those that don't String to Date&Time Column Rename Table Creator Cell Splitter Table Creator Cell Splitter Cross Joiner Column Rename String to Date&Time Rule Engine Row Splitter

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: brian
Created at: 2021-04-14
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.3.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!