Icon

Identify Months Between Two Dates (No Loops)

Identify Months Between 2 Dates (No Loops)

Identify Months Between 2 Dates (No Loops)

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

Data Input(Make sure to include only 2 columnsto avoid cluttering. You canalways re-attach extra columns later on.)(Also make sure the column namesare changed accordingly to fit this workflow.)starting month & yearending month & year(Just ignore the warning sign)(Just ignore the warning sign)Marking the correctending month based onperiod rangeFull Range of Possible MonthsLabeling periodrange falling within the same year with "0" and the ones that extend to the next year(s)with "1" or moreMarking the possiblestarting monthsMarking the possibleending monthsCleanupCleanupGetting back the original identifier row IDsCleanupRestructuring the table to resemble the original datasetSplitting the months to three partsusing the previously marked X signsOur target monthsare now identified to sit betweenthe correct starting & ending monthswhich are marked as X.Cleanup& isolating the rightcolumn containing the right month namesin the right orderWe now prepareour vector tableCreate the vector tableCalling the additional columnsReordering the column positions, renaming them and removing 1 unwanted columnHow to read the table?0 : The month doesn't belong within the period range1: The month appears once within the period range(Applicable for all cases)2 : The month appears more than once within the period range(Applicable only for a period range beyond 12 months)If in doubt, double check with the starting & ending dates.Table Creator Extract Date&TimeFields Extract Date&TimeFields Column Appender Missing Value Column Aggregator Rule Engine Table Creator Column Aggregator Ungroup Math Formula Column Comparator Column Comparator Column Filter Cell Splitter Column Aggregator Column Filter RowID Cell Splitter Column Filter GroupBy Column Filter Cell Splitter Column Expressions Column Filter Strings To Document Bag Of WordsCreator TF Document Vector Document DataExtractor Table Manipulator Data Input(Make sure to include only 2 columnsto avoid cluttering. You canalways re-attach extra columns later on.)(Also make sure the column namesare changed accordingly to fit this workflow.)starting month & yearending month & year(Just ignore the warning sign)(Just ignore the warning sign)Marking the correctending month based onperiod rangeFull Range of Possible MonthsLabeling periodrange falling within the same year with "0" and the ones that extend to the next year(s)with "1" or moreMarking the possiblestarting monthsMarking the possibleending monthsCleanupCleanupGetting back the original identifier row IDsCleanupRestructuring the table to resemble the original datasetSplitting the months to three partsusing the previously marked X signsOur target monthsare now identified to sit betweenthe correct starting & ending monthswhich are marked as X.Cleanup& isolating the rightcolumn containing the right month namesin the right orderWe now prepareour vector tableCreate the vector tableCalling the additional columnsReordering the column positions, renaming them and removing 1 unwanted columnHow to read the table?0 : The month doesn't belong within the period range1: The month appears once within the period range(Applicable for all cases)2 : The month appears more than once within the period range(Applicable only for a period range beyond 12 months)If in doubt, double check with the starting & ending dates.Table Creator Extract Date&TimeFields Extract Date&TimeFields Column Appender Missing Value Column Aggregator Rule Engine Table Creator Column Aggregator Ungroup Math Formula Column Comparator Column Comparator Column Filter Cell Splitter Column Aggregator Column Filter RowID Cell Splitter Column Filter GroupBy Column Filter Cell Splitter Column Expressions Column Filter Strings To Document Bag Of WordsCreator TF Document Vector Document DataExtractor Table Manipulator

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: p912366
Created at: 2022-09-08
On NodePit since: 2022-09-10
Last update: 2024-04-27
Created with KNIME version: v4.6.1

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

Try NodePit Runner!