Icon

Challenge 5 - Date to Fiscal Year

Solution to Just KNIME It! challenge #5.

Lookup tableContractsConvert Contract Dateto Date&TimeFind rows withinstart and end datesAttach detected fiscal year to dataGather results for all definedfiscal yearsExcel Reader Excel Reader Table Row ToVariable Loop Start String to Date&Time Date&Time-basedRow Filter ConstantValue Column Loop End Lookup tableContractsConvert Contract Dateto Date&TimeFind rows withinstart and end datesAttach detected fiscal year to dataGather results for all definedfiscal yearsExcel Reader Excel Reader Table Row ToVariable Loop Start String to Date&Time Date&Time-basedRow Filter ConstantValue Column Loop End

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: Scott
Created at: 2020-09-24
On NodePit since: 2022-02-26
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: justknimeitjustknimeit-5

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

Try NodePit Runner!