Icon

justknimeit-5_​Victor

Description: 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 aperiod 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 thestart 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. Data available at : https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%205%20-%20Datasets~HfelRTR4GYlK0xcm/ Create ID column (not necessary) Generate file "fiscal_years_lookup_table" without missing years.Possibility to change the parameters in the time data creator nodes to add more years (betterscalability than manually add rows for new years). contract_dates_table.xlsxConvert stringinto DateReplace "/" by "."Comparecontract date withfiscal year datesSort datesLoop overfiscal yearConcatenate resultsGeneraterowIDModify IDSort ID columnfirstFilter emptyFiscal YearsCreate startfiscal yearCreate endfiscal yearJoin start andend fiscal dateswith keyAdd Key FY basedon end fiscal dateSort column Excel Reader String to Date&Time String Manipulation Rule Engine Sorter Table Row ToVariable Loop Start Loop End RowID String Manipulation Column Resorter Row Filter Create Date&TimeRange Create Date&TimeRange Joiner String Manipulation Column Resorter Description: 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 aperiod 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 thestart 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. Data available at : https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%205%20-%20Datasets~HfelRTR4GYlK0xcm/ Create ID column (not necessary) Generate file "fiscal_years_lookup_table" without missing years.Possibility to change the parameters in the time data creator nodes to add more years (betterscalability than manually add rows for new years). contract_dates_table.xlsxConvert stringinto DateReplace "/" by "."Comparecontract date withfiscal year datesSort datesLoop overfiscal yearConcatenate resultsGeneraterowIDModify IDSort ID columnfirstFilter emptyFiscal YearsCreate startfiscal yearCreate endfiscal yearJoin start andend fiscal dateswith keyAdd Key FY basedon end fiscal dateSort columnExcel Reader String to Date&Time String Manipulation Rule Engine Sorter Table Row ToVariable Loop Start Loop End RowID String Manipulation Column Resorter Row Filter Create Date&TimeRange Create Date&TimeRange Joiner String Manipulation Column Resorter

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: victo
Created at: 2022-02-23
On NodePit since: 2022-02-25
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!