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