Icon

Contract Weeks

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Pasted forum data to table populate missing end date as "end of year" Node 2Node 3Node 4get yearmissing end dateto bottomget end if yearend of yearasdateremove "year"columnbring back togethercalculate weeksbetween start and endgenerate rowsrank withinname and start date to getsequence numbercalcnew week startrank is "offset"so reduce by 1so it starts at offset 0for first weekincrease weeksby 1 to makeinclusive ofend weekand make into intso "One Row to Many" can see ittidy upreturn Name, week start, hoursKeep only lateststart date for eachname Table Creator Row to Column Names String to Date&Time Extract Date&TimeFields Row Splitter String Manipulation String to Date&Time Column Filter Concatenate Date&TimeDifference One Row to Many Rank Date&Time Shift Math Formula Math Formula Column Filter DuplicateRow Filter Pasted forum data to table populate missing end date as "end of year" Node 2Node 3Node 4get yearmissing end dateto bottomget end if yearend of yearasdateremove "year"columnbring back togethercalculate weeksbetween start and endgenerate rowsrank withinname and start date to getsequence numbercalcnew week startrank is "offset"so reduce by 1so it starts at offset 0for first weekincrease weeksby 1 to makeinclusive ofend weekand make into intso "One Row to Many" can see ittidy upreturn Name, week start, hoursKeep only lateststart date for eachname Table Creator Row to Column Names String to Date&Time Extract Date&TimeFields Row Splitter String Manipulation String to Date&Time Column Filter Concatenate Date&TimeDifference One Row to Many Rank Date&Time Shift Math Formula Math Formula Column Filter DuplicateRow 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: BATEB031
Created at: 2023-12-22
On NodePit since: 2023-12-23
Last update: 2024-04-27
Created with KNIME version: v5.2.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!