Icon

Just Knime It Week 5 v.1

Just Knime It Week 5 v.1
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 theircorresponding 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 tocountry, 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.Author: Victor PalaciosDataset: Labels for fiscal years and contract dates in the KNIME Hub Our solution will appear here next Tuesday. In the meantime, feel free to discuss your work on the KNIME forum or on social media using the hashtag #justknimeit.Remember to upload your solution with tag justknimeit-5 to your public space on the KNIME Hub. To increase the visibility of your solution, also post it to this challenge thread on the KNIME forum. DatesPeriodlookup tableDate correctionLoop periodsAssign periodCollectresultsFilter the validperiodsTidy up Excel Reader Excel Reader String to Date&Time Table Row ToVariable Loop Start Rule Engine Loop End Row Filter Column Filter 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 theircorresponding 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 tocountry, 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.Author: Victor PalaciosDataset: Labels for fiscal years and contract dates in the KNIME Hub Our solution will appear here next Tuesday. In the meantime, feel free to discuss your work on the KNIME forum or on social media using the hashtag #justknimeit.Remember to upload your solution with tag justknimeit-5 to your public space on the KNIME Hub. To increase the visibility of your solution, also post it to this challenge thread on the KNIME forum. DatesPeriodlookup tableDate correctionLoop periodsAssign periodCollectresultsFilter the validperiodsTidy up Excel Reader Excel Reader String to Date&Time Table Row ToVariable Loop Start Rule Engine Loop End Row Filter 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: Loeffler
Created at: 2022-02-24
On NodePit since: 2022-02-26
Last update: 2024-05-01
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!