Icon

challenge5 contract dates

challenge5 contract dates
ContractsNode 3Node 37Node 38decide wheaterto add 1 to YEARcalculate Fiscal Yearcolumn cleaningLookup-Table:Fiscal Yearscreate 'key'Port#1: All Contracts from Lookup-TablePort#2: Contracts not fitting to Lookup-TableGet Month from DateGrouping MonthCosmetics:rename columnExcel Reader String to Date&Time Extract Date&TimeFields Table Rowto Variable Rule Engine Math Formula Column Filter Excel Reader String Manipulation Reference RowSplitter Extract Date&TimeFields GroupBy Column Rename ContractsNode 3Node 37Node 38decide wheaterto add 1 to YEARcalculate Fiscal Yearcolumn cleaningLookup-Table:Fiscal Yearscreate 'key'Port#1: All Contracts from Lookup-TablePort#2: Contracts not fitting to Lookup-TableGet Month from DateGrouping MonthCosmetics:rename columnExcel Reader String to Date&Time Extract Date&TimeFields Table Rowto Variable Rule Engine Math Formula Column Filter Excel Reader String Manipulation Reference RowSplitter Extract Date&TimeFields GroupBy Column Rename

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: Micha
Created at: 2022-02-24
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!