Icon

KNIME_​challenge5_​solution

KNIME_challenge5_solution
Challenge 5: Date to Fiscal YearLevel: MediumDescription: In the accounting firm you work for, you are given contracts which were executed on different dates.Your goal is to create a method that can label each of these contracts with their corresponding fiscal year. Note: Afiscal year is a period of 12 months that is used in government accounting, usually for budget purposes andfinancial reporting. Its definition varies from country to country, so your solution should be flexible and include flowvariables for both the start and the end dates of the fiscal year. As an example, the federal fiscal year in the UnitedStates is the 12-month period that begins on October 1st and ends on September 30th of the following year. +---------------------+--------+| Contract Start Date | Key |+---------------------+--------+| 2011-06-30 | FY2012 || 2011-12-08 | FY2012 || 2011-12-08 | FY2012 || 2012-02-21 | FY2012 || 2011-03-24 | FY2012 || 2011-03-24 | FY2012 || 2013-02-07 | FY2013 || 2012-08-03 | FY2013 || 2012-11-30 | FY2013 |.............+---------------------+--------+ fiscal_years_lookup_tablecontract_dates_tableNode 13Node 15Node 16Node 19Node 21Node 22Node 23Node 25 Excel Reader Excel Reader Create Date&TimeRange Column Expressions Column Expressions Select startdate and year Select end year String to Date&Time Table Row ToVariable Loop Start Date&Time-basedRow Filter Loop End Variable toTable Column View result Challenge 5: Date to Fiscal YearLevel: MediumDescription: In the accounting firm you work for, you are given contracts which were executed on different dates.Your goal is to create a method that can label each of these contracts with their corresponding fiscal year. Note: Afiscal year is a period of 12 months that is used in government accounting, usually for budget purposes andfinancial reporting. Its definition varies from country to country, so your solution should be flexible and include flowvariables for both the start and the end dates of the fiscal year. As an example, the federal fiscal year in the UnitedStates is the 12-month period that begins on October 1st and ends on September 30th of the following year. +---------------------+--------+| Contract Start Date | Key |+---------------------+--------+| 2011-06-30 | FY2012 || 2011-12-08 | FY2012 || 2011-12-08 | FY2012 || 2012-02-21 | FY2012 || 2011-03-24 | FY2012 || 2011-03-24 | FY2012 || 2013-02-07 | FY2013 || 2012-08-03 | FY2013 || 2012-11-30 | FY2013 |.............+---------------------+--------+ fiscal_years_lookup_tablecontract_dates_tableNode 13Node 15Node 16Node 19Node 21Node 22Node 23Node 25 Excel Reader Excel Reader Create Date&TimeRange Column Expressions Column Expressions Select startdate and year Select end year String to Date&Time Table Row ToVariable Loop Start Date&Time-basedRow Filter Loop End Variable toTable Column View result

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: MMU
Created at: 2022-02-16
On NodePit since: 2022-02-28
Last update: 2024-11-21
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!