Icon

Date to Fiscal Year - Challenge5

Date to Fiscal Year - Challenge5
Just KNIME It! - Challenge 5: Date to Fiscal YearEntering_Fiscal_Year_Period component allow to define the period of fiscal year with simple sliders, for starting and ending months, it will break if period entered incorrectly.Rule Engine will simply check contract fiscal year and will assign the correct label. contract_dates_tableextract month and yearconvert contractfrom string to dateassign correct fiscal year labelaccording to period definitioncreating fiscal year labelsfor contract yearand year+1leaving onlycontract dateand fiscal year label Excel Reader Entering_Fiscal_Year_Period Extract Date&TimeFields String to Date&Time Rule Engine Column Expressions Column Filter Just KNIME It! - Challenge 5: Date to Fiscal YearEntering_Fiscal_Year_Period component allow to define the period of fiscal year with simple sliders, for starting and ending months, it will break if period entered incorrectly.Rule Engine will simply check contract fiscal year and will assign the correct label. contract_dates_tableextract month and yearconvert contractfrom string to dateassign correct fiscal year labelaccording to period definitioncreating fiscal year labelsfor contract yearand year+1leaving onlycontract dateand fiscal year labelExcel Reader Entering_Fiscal_Year_Period Extract Date&TimeFields String to Date&Time Rule Engine Column Expressions Column 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: dabekasi1
Created at: 2022-02-23
On NodePit since: 2022-03-02
Last update: 2024-11-18
Created with KNIME version: v4.5.0
Tags: justknimeit-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!