Icon

Challenge 5 - Date to Fiscal Year AV

Challenge 5 - Date to Fiscal Year - Solution

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: A fiscal year is a period of 12 months that is used in government accounting, usually for budget purposes and financial reporting. Its definition varies from country to country, so your solution should be flexible and include flow variables for both the start and the end dates of the fiscal year. As an example, the federal fiscal year in the United States is the 12-month period that begins on October 1st and ends on September 30th of the following year.

Challenge 5 - Date to Fiscal YearIn 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 thesecontracts with their corresponding fiscal year. Note: A fiscal year is a period of 12 months that is used in government accounting, usually for budget purposes and financial reporting. Its definition varies fromcountry to country, so your solution should be flexible and include flow variables for both the start and the end dates of the fiscal year. As an example, the federalfiscal year in the United States is the 12-month period that begins on October 1st and ends on September 30th of the following year. Collect only contracts that fallwithin the current fiscal year loopLookup table with fiscal years (FY)Contract dataLoop over FYSort DatesYear column addedCollect resultsDate&Time-basedRow Filter String to Date&Time Excel Reader Excel Reader Table Row ToVariable Loop Start Sorter Column Expressions Loop End Challenge 5 - Date to Fiscal YearIn 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 thesecontracts with their corresponding fiscal year. Note: A fiscal year is a period of 12 months that is used in government accounting, usually for budget purposes and financial reporting. Its definition varies fromcountry to country, so your solution should be flexible and include flow variables for both the start and the end dates of the fiscal year. As an example, the federalfiscal year in the United States is the 12-month period that begins on October 1st and ends on September 30th of the following year. Collect only contracts that fallwithin the current fiscal year loopLookup table with fiscal years (FY)Contract dataLoop over FYSort DatesYear column addedCollect resultsDate&Time-basedRow Filter String to Date&Time Excel Reader Excel Reader Table Row ToVariable Loop Start Sorter Column Expressions Loop End

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: Scott
Created at: 2020-09-24
On NodePit since: 2022-05-21
Last update: 2024-11-21
Created with KNIME version: v4.5.2
Tags: justknimeitjustknimeit-5flow variablesloop

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!