Icon

Challenge 5 - Date to Fiscal Year

First approach: Label contract dates based on provided FY date listLimitations and Possible Enhancements: Contract dates with FY not stated in the FY source list are not labelled and are missing in the output Second approach: Label contract dates based on provided FY date listLimitations and Possible Enhancements: Add in the FY component automated controls to certify that the user input is valid MANDATORY CONFIGURATION Imports Contract Date DataConverts Datesinto Time-SeriesImports mapped FY'sLabel every contract date with the respective iteration FY Looping through alllisted FY's availableAdds the current FY of the iteration to the columnConsolidates all looped FY'sLooping through alllisted FY's availableAdds the current FY of the iteration to the columnLabel every contract date with the respective iteration FY Consolidates all looped FY'sBased on the contract data,calculates the FY's for the entire datasetExcel Reader String to Date&Time Excel Reader Date&Time-basedRow Filter Table Row ToVariable Loop Start Variable toTable Column Loop End Table Row ToVariable Loop Start Variable toTable Column Date&Time-basedRow Filter Loop End Fiscal YearCalculator First approach: Label contract dates based on provided FY date listLimitations and Possible Enhancements: Contract dates with FY not stated in the FY source list are not labelled and are missing in the output Second approach: Label contract dates based on provided FY date listLimitations and Possible Enhancements: Add in the FY component automated controls to certify that the user input is valid MANDATORY CONFIGURATION Imports Contract Date DataConverts Datesinto Time-SeriesImports mapped FY'sLabel every contract date with the respective iteration FY Looping through alllisted FY's availableAdds the current FY of the iteration to the columnConsolidates all looped FY'sLooping through alllisted FY's availableAdds the current FY of the iteration to the columnLabel every contract date with the respective iteration FY Consolidates all looped FY'sBased on the contract data,calculates the FY's for the entire datasetExcel Reader String to Date&Time Excel Reader Date&Time-basedRow Filter Table Row ToVariable Loop Start Variable toTable Column Loop End Table Row ToVariable Loop Start Variable toTable Column Date&Time-basedRow Filter Loop End Fiscal YearCalculator

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: bernardo.silva
Created at: 2022-02-24
On NodePit since: 2022-02-28
Last update: 2024-04-27
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!