Icon

2019_​05_​02_​From_​One_​Row_​To_​Many_​Loopless

Creating new rows based on difference between 2 date fieldsThis workflow using Table Row to Variable Loop Start and Create Date&Time Range nodes creates new rows based on difference between 2 datefields in input table. Second approach uses One Row to Many node to avoid loop.Forum link: https://forum.knime.com/t/creating-new-rows-based-on-difference-between-2-date-fields/8923 Input dataCreate dates in betweenAdd PersonAdd ActivitySort columnsEnd LoopInput dataFrom String to Date&Time formatCalculate differenceMultiply rowsDiff +1 to IntRank for shifting purposeShiftSort out tableOne row = one iterationDiff +1 to Int Table Creator Create Date&TimeRange ConstantValue Column ConstantValue Column Column Resorter Loop End Table Creator String to Date&Time Date&TimeDifference One Row to Many Math Formula Rank Date&Time Shift Table Manipulator Table Row ToVariable Loop Start Math Formula Creating new rows based on difference between 2 date fieldsThis workflow using Table Row to Variable Loop Start and Create Date&Time Range nodes creates new rows based on difference between 2 datefields in input table. Second approach uses One Row to Many node to avoid loop.Forum link: https://forum.knime.com/t/creating-new-rows-based-on-difference-between-2-date-fields/8923 Input dataCreate dates in betweenAdd PersonAdd ActivitySort columnsEnd LoopInput dataFrom String to Date&Time formatCalculate differenceMultiply rowsDiff +1 to IntRank for shifting purposeShiftSort out tableOne row = one iterationDiff +1 to Int Table Creator Create Date&TimeRange ConstantValue Column ConstantValue Column Column Resorter Loop End Table Creator String to Date&Time Date&TimeDifference One Row to Many Math Formula Rank Date&Time Shift Table Manipulator Table Row ToVariable Loop Start Math Formula

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: Johnny
Created at: 2019-01-03
On NodePit since: 2022-02-06
Last update: 2024-04-24
Created with KNIME version: v4.4.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!