Icon

KNIME_​Challenge5_​Fiscal_​Years

Contracts DateTableFiscal YearLookup TableContract Start DateYearMonth (number)If month >= 10THENYear + 1Add "FY" to KeyKeyKEEPContract Start DateFiscal YearExcel Reader Excel Reader String to Date&Time Extract Date&TimeFields Math Formula String Manipulation Number To String Column Filter Contracts DateTableFiscal YearLookup TableContract Start DateYearMonth (number)If month >= 10THENYear + 1Add "FY" to KeyKeyKEEPContract Start DateFiscal YearExcel Reader Excel Reader String to Date&Time Extract Date&TimeFields Math Formula String Manipulation Number To String Column Filter

Nodes

Extensions

Links