Icon

jKi-5

jKi-5
Description: In the accounting firm you work for, you are given contracts whichwere executed on different dates. Your goal is to create a method that canlabel each of these contracts with their corresponding fiscal year. Note: A fiscalyear is a period of 12 months that is used in government accounting, usuallyfor budget purposes and financial reporting. Its definition varies from country tocountry, so your solution should be flexible and include flow variables for boththe start and the end dates of the fiscal year. As an example, the federal fiscalyear in the United States is the 12-month period that begins on October 1stand ends on September 30th of the following year. contract datesfisical yearlookupNode 3filter contract datesbased on fisical yearNode 6add fisical yearlabelNode 10 Excel Reader Excel Reader String to Date&Time Date&Time-basedRow Filter Table Row ToVariable Loop Start Variable toTable Column Loop End Description: In the accounting firm you work for, you are given contracts whichwere executed on different dates. Your goal is to create a method that canlabel each of these contracts with their corresponding fiscal year. Note: A fiscalyear is a period of 12 months that is used in government accounting, usuallyfor budget purposes and financial reporting. Its definition varies from country tocountry, so your solution should be flexible and include flow variables for boththe start and the end dates of the fiscal year. As an example, the federal fiscalyear in the United States is the 12-month period that begins on October 1stand ends on September 30th of the following year. contract datesfisical yearlookupNode 3filter contract datesbased on fisical yearNode 6add fisical yearlabelNode 10Excel Reader Excel Reader String to Date&Time Date&Time-basedRow Filter Table Row ToVariable Loop Start Variable toTable Column 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: franzc
Created at: 2022-02-23
On NodePit since: 2022-02-25
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: justknimeit-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!