Icon

KNIME_​Challenge5_​Fiscal_​Years

Contracts DateTableFiscal YearLookup TableContract Start DateYearMonth (number)If month >= 10THENYear + 1Add "FY" to KeyKeyKEEPContract Start DateFiscal YearNumber of contractsby FYTop 10 yearsExcel Reader Excel Reader String to Date&Time Extract Date&TimeFields Math Formula String Manipulation Number To String Column Filter GroupBy Top k Selector Contracts DateTableFiscal YearLookup TableContract Start DateYearMonth (number)If month >= 10THENYear + 1Add "FY" to KeyKeyKEEPContract Start DateFiscal YearNumber of contractsby FYTop 10 yearsExcel Reader Excel Reader String to Date&Time Extract Date&TimeFields Math Formula String Manipulation Number To String Column Filter GroupBy Top k Selector

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: samja
Created at: 2022-02-23
On NodePit since: 2022-02-24
Last update: 2024-11-21
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!