Icon

challenge 20220223

Challenge 5: Date to Fiscal YearLevel: MediumDescription: In the accounting firm you work for, you are given contracts which were executedon 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, usuallyfor budget purposes and financial reporting. Its definition varies from country to country, soyour solution should be flexible and include flow variables for both the start and the enddates of the fiscal year. As an example, the federal fiscal year in the United States is the 12-month period thatbegins 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 workon 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 KNIMEHub. To increase the visibility of your solution, also post it to this challenge thread on theKNIME forum. apply rulescreate rulesNode 8Node 10Node 11Node 15make rules into collectionNode 19Node 20 Rule Engine Column Expressions String to Date&Time Date&Time to String String to Date&Time Table Columnto Variable GroupBy Excel Reader Excel Reader Challenge 5: Date to Fiscal YearLevel: MediumDescription: In the accounting firm you work for, you are given contracts which were executedon 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, usuallyfor budget purposes and financial reporting. Its definition varies from country to country, soyour solution should be flexible and include flow variables for both the start and the enddates of the fiscal year. As an example, the federal fiscal year in the United States is the 12-month period thatbegins 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 workon 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 KNIMEHub. To increase the visibility of your solution, also post it to this challenge thread on theKNIME forum. apply rulescreate rulesNode 8Node 10Node 11Node 15make rules into collectionNode 19Node 20Rule Engine Column Expressions String to Date&Time Date&Time to String String to Date&Time Table Columnto Variable GroupBy Excel Reader Excel Reader

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: Alex Martin
Created at: 2022-02-25
On NodePit since: 2022-02-26
Last update: 2024-04-28
Created with KNIME version: v4.5.1

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

Try NodePit Runner!