Icon

Convert and modify dates and times - 3 - group loop and branch demo

Sample DataConvert TimeConvert DateMake timeinto a string again that canbe used by row splitterin comparisontimes BEFORE063000 go totop portAdjust timesin rangesUpdate date to previous daybring rows back togetherTime put backto being a time columnchoose branchusingvariableRules to choosethe requiredbranchGroup by branchcreate a variablefor branch choicemessagemessagemessagemessageAdjust timesin rangesUpdate date to previous daysort back in rowid order(requires newer sorternode with alphanumericstring sorting )Extract Data Tablefrom Delimited Text String to Date&Time String to Date&Time Date&Time to String Rule-basedRow Splitter Rule Engine Date&Time Shift Concatenate String to Date&Time CASE Switch Start CASE Switch End Rule Engine Group Loop Start Loop End Table Rowto Variable String Manipulation String Manipulation String Manipulation String Manipulation Rule Engine Date&Time Shift Sorter Sample DataConvert TimeConvert DateMake timeinto a string again that canbe used by row splitterin comparisontimes BEFORE063000 go totop portAdjust timesin rangesUpdate date to previous daybring rows back togetherTime put backto being a time columnchoose branchusingvariableRules to choosethe requiredbranchGroup by branchcreate a variablefor branch choicemessagemessagemessagemessageAdjust timesin rangesUpdate date to previous daysort back in rowid order(requires newer sorternode with alphanumericstring sorting )Extract Data Tablefrom Delimited Text String to Date&Time String to Date&Time Date&Time to String Rule-basedRow Splitter Rule Engine Date&Time Shift Concatenate String to Date&Time CASE Switch Start CASE Switch End Rule Engine Group Loop Start Loop End Table Rowto Variable String Manipulation String Manipulation String Manipulation String Manipulation Rule Engine Date&Time Shift Sorter

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: bbate
Created at: 2023-06-09
On NodePit since: 2023-06-12
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!