Icon

Challenge-05

Contract DatesFiscal YearsSorts the contractsby dateConverts strings to datesfor easier sortingsplit start intocolumnsconvert starts toabsolute timesplits start into columnssplits end intocolumnsconverts start toabsolute timeconverts ends toabsolute timeremoves extracolumnsremoves extracolumnsLoops overcontractsLoops overfiscal yearends contractloopadds columnsto match onadds columnto match oncombines tablesends fiscalloopremoves extracolumnsempty table to fillwith matched yearappends rowto tablechecks if date infiscal rangeadds back rowswithout fiscal yearremoves extracolumnsremoves extracolumnsreplaces missingvalues with unknownSorts the contractsby datewrites outresultsremoves extracolumnsNode 54Node 56Node 57Node 58Excel Reader Excel Reader Sorter String to Date&Time Cell Splitter Math Formula Cell Splitter Cell Splitter Math Formula Math Formula Column Filter Column Filter Chunk Loop Start Chunk Loop Start Loop End ConstantValue Column ConstantValue Column Joiner Loop End Column Filter Table Creator Concatenate Rule-basedRow Filter Joiner Column Filter Column Filter Missing Value Sorter Excel Writer Column Filter Custom Fiscal Year Concatenate Custom Fiscal Year String to Date&Time Variable toTable Row Date&Time to String Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Contract DatesFiscal YearsSorts the contractsby dateConverts strings to datesfor easier sortingsplit start intocolumnsconvert starts toabsolute timesplits start into columnssplits end intocolumnsconverts start toabsolute timeconverts ends toabsolute timeremoves extracolumnsremoves extracolumnsLoops overcontractsLoops overfiscal yearends contractloopadds columnsto match onadds columnto match oncombines tablesends fiscalloopremoves extracolumnsempty table to fillwith matched yearappends rowto tablechecks if date infiscal rangeadds back rowswithout fiscal yearremoves extracolumnsremoves extracolumnsreplaces missingvalues with unknownSorts the contractsby datewrites outresultsremoves extracolumnsNode 54Node 56Node 57Node 58Excel Reader Excel Reader Sorter String to Date&Time Cell Splitter Math Formula Cell Splitter Cell Splitter Math Formula Math Formula Column Filter Column Filter Chunk Loop Start Chunk Loop Start Loop End ConstantValue Column ConstantValue Column Joiner Loop End Column Filter Table Creator Concatenate Rule-basedRow Filter Joiner Column Filter Column Filter Missing Value Sorter Excel Writer Column Filter Custom Fiscal Year Concatenate Custom Fiscal Year String to Date&Time Variable toTable Row Date&Time to String Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year Custom Fiscal Year

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: ryanj_4h7ruxj
Created at: 2022-02-25
On NodePit since: 2022-02-26
Last update: 2024-05-01
Created with KNIME version: v4.5.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!