Icon

kn_​knime_​it_​5

Just KNIME It Challenge 5 - Date to Fiscal Year

Just KNIME It Challenge 5 - Date to Fiscal Year

I deliberately used a loop and a rule engine to show that dates can be used there :-)

Challenge 5: Date to Fiscal YearLevel: MediumDescription: In the accounting firm you work for, you are given contracts which were executed ondifferent 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 governmentaccounting, 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 enddates of the fiscal year. As an example, the federal fiscal year in the United States is the 12-monthperiod 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 theKNIME 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. Toincrease the visibility of your solution, also post it to this challenge thread on the KNIME forum. Just KNIME It Challenge 5 - Date to Fiscal YearI deliberately used a loop and a rule engine to show that dates can be used there :-) contract_dates_table.xlsxfiscal_years_lookup_table.xlsxdd/MM/yyyySTART$Contract Start Date$ >= $${SStart}$$ AND $Contract Start Date$ <= $${SEnd}$$ => TRUETRUE => FALSEFiscal_YearENDresult.xlsx"data"result.xlsx"overview" Excel Reader Excel Reader String to Date&Time Table Row ToVariable Loop Start Rule-basedRow Filter ConstantValue Column Loop End Sorter GroupBy Excel Writer Excel Writer Challenge 5: Date to Fiscal YearLevel: MediumDescription: In the accounting firm you work for, you are given contracts which were executed ondifferent 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 governmentaccounting, 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 enddates of the fiscal year. As an example, the federal fiscal year in the United States is the 12-monthperiod 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 theKNIME 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. Toincrease the visibility of your solution, also post it to this challenge thread on the KNIME forum. Just KNIME It Challenge 5 - Date to Fiscal YearI deliberately used a loop and a rule engine to show that dates can be used there :-) contract_dates_table.xlsxfiscal_years_lookup_table.xlsxdd/MM/yyyySTART$Contract Start Date$ >= $${SStart}$$ AND $Contract Start Date$ <= $${SEnd}$$ => TRUETRUE => FALSEFiscal_YearENDresult.xlsx"data"result.xlsx"overview"Excel Reader Excel Reader String to Date&Time Table Row ToVariable Loop Start Rule-basedRow Filter ConstantValue Column Loop End Sorter GroupBy Excel Writer Excel Writer

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: m_lauber
Created at: 2022-02-23
On NodePit since: 2022-02-24
Last update: 2024-05-01
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!