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