Icon

Different date formats in one column

Node 1Add a sortingcolumnKeeping only thesys_updated_oncolumnSeparate thedate formatsSplit byslashSplit byspaceSplit bycolonjoin the splitvalues backtogetherTidy upFor dash format,just keep as isNode 11Sort back inoriginal orderRemovesortcolumnNode 14CSV Reader Counter Generation Column Filter Row Splitter Cell Splitter Cell Splitter Cell Splitter String Manipulation Column Filter Rule Engine Concatenate Sorter Column Filter String to Date&Time Node 1Add a sortingcolumnKeeping only thesys_updated_oncolumnSeparate thedate formatsSplit byslashSplit byspaceSplit bycolonjoin the splitvalues backtogetherTidy upFor dash format,just keep as isNode 11Sort back inoriginal orderRemovesortcolumnNode 14CSV Reader Counter Generation Column Filter Row Splitter Cell Splitter Cell Splitter Cell Splitter String Manipulation Column Filter Rule Engine Concatenate Sorter Column Filter String to Date&Time

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: bruno
Created at: 2022-06-23
On NodePit since: 2022-06-24
Last update: 2024-05-02
Created with KNIME version: v4.5.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!