Icon

KNIME_​Date_​Handler

Sample dataDefine date formattypesfrom regex patternsModify this to includeall the possible regex patterns for DateValueand the appropriate date format patternfor eachConvert datevaluestring usingchosen date formatFilter where there isno yearpresent inthe dateApply default year (2019) to end of DateValue stringBring back togetherProcess eachrow in a loop so that we can usedifferent date-format flowvariable for each iterationGet Date format mask as flow variableto usefor this rowCollect resultsApply a rowsequence numberto easily sort rowsback intooriginal orderat other endtidy uprowstidy upcolumnsalternative to loop.Should be faster for larger data sets,using java DateTimeFormatterclasstidy uprowstidy upcolumnsTable Creator Rule Engine String to Date&Time Row Splitter String Manipulation Concatenate Group Loop Start Table Rowto Variable Loop End Counter Generation Sorter Column Filter Java Snippet Sorter Column Filter Sample dataDefine date formattypesfrom regex patternsModify this to includeall the possible regex patterns for DateValueand the appropriate date format patternfor eachConvert datevaluestring usingchosen date formatFilter where there isno yearpresent inthe dateApply default year (2019) to end of DateValue stringBring back togetherProcess eachrow in a loop so that we can usedifferent date-format flowvariable for each iterationGet Date format mask as flow variableto usefor this rowCollect resultsApply a rowsequence numberto easily sort rowsback intooriginal orderat other endtidy uprowstidy upcolumnsalternative to loop.Should be faster for larger data sets,using java DateTimeFormatterclasstidy uprowstidy upcolumnsTable Creator Rule Engine String to Date&Time Row Splitter String Manipulation Concatenate Group Loop Start Table Rowto Variable Loop End Counter Generation Sorter Column Filter Java Snippet Sorter Column 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: brian
Created at: 2022-01-17
On NodePit since: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.5.0

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

Try NodePit Runner!