Icon

justknimeit-5

create a variable for "out of range" entries (basically entries, that do not match any of the givenFiscal Years) Just KNIME It Challenge 5Description: 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 fiscalyear. 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 to country, so your solution should be flexibleand 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 September30th of the following year.URL of the Challenge: https://www.knime.com/just-knime-itDataset: https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%205%20-%20Datasets~HfelRTR4GYlK0xcm/ importcontract datesimportfiscal yearsconvertstring > datejoin both tables togetherfor Rule Enginecheck date range ANDif Contract Date is outof range get earliest dateper rowkeep only1st row(earliest FY)keep only 1st date of1st rowdate > vardel allrows withmissing valsremove all duplicate contractssort by date asc.createunique contract IDtidy colsExcel Reader Excel Reader String to Date&Time Cross Joiner Rule Engine Column Aggregator Row Filter Column Filter Table Rowto Variable Row Filter DuplicateRow Filter Sorter String Manipulation Column Filter create a variable for "out of range" entries (basically entries, that do not match any of the givenFiscal Years) Just KNIME It Challenge 5Description: 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 fiscalyear. 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 to country, so your solution should be flexibleand 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 September30th of the following year.URL of the Challenge: https://www.knime.com/just-knime-itDataset: https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%205%20-%20Datasets~HfelRTR4GYlK0xcm/ importcontract datesimportfiscal yearsconvertstring > datejoin both tables togetherfor Rule Enginecheck date range ANDif Contract Date is outof range get earliest dateper rowkeep only1st row(earliest FY)keep only 1st date of1st rowdate > vardel allrows withmissing valsremove all duplicate contractssort by date asc.createuniquecontract IDtidy colsExcel Reader Excel Reader String to Date&Time Cross Joiner Rule Engine Column Aggregator Row Filter Column Filter Table Rowto Variable Row Filter DuplicateRow Filter Sorter String Manipulation 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: m1pegv
Created at: 2022-02-24
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!