Icon

Challenge5_​fiscalyear_​lookup

Challenge5_fiscalyear

Solution to Challenge 5
- no loops, no variables

this is just to bring the table back in original order based on original rowIDs Solution to KNIME Challenge 5.2022Idea: Use a combination of Joiners and Filters torealize a lookup (due to the fact that KNIMEJoiner node does not support join conditions with<=, >= ,or temporal conditions) contract_dates_table.xlsxfiscal_years_lookup_table.xlsxthis table is not complete, i.e. there contract dates without corresponding missing yearconvert to date fieldcombine both tablesfilter out all records that match the conditioncontract date between start and endNOTE: Here we loose all records without match in lookup tablewe do a left join withoriginal table to get backall "lost" recordsfill missing Fiscal Year with "NA"Node 9Node 10Node 11Node 12 Excel Reader Excel Reader String to Date&Time Cross Joiner Rule-basedRow Filter Joiner Missing Value String Manipulation Sorter Column Filter String To Number this is just to bring the table back in original order based on original rowIDs Solution to KNIME Challenge 5.2022Idea: Use a combination of Joiners and Filters torealize a lookup (due to the fact that KNIMEJoiner node does not support join conditions with<=, >= ,or temporal conditions) contract_dates_table.xlsxfiscal_years_lookup_table.xlsxthis table is not complete, i.e. there contract dates without corresponding missing yearconvert to date fieldcombine both tablesfilter out all records that match the conditioncontract date between start and endNOTE: Here we loose all records without match in lookup tablewe do a left join withoriginal table to get backall "lost" recordsfill missing Fiscal Year with "NA"Node 9Node 10Node 11Node 12Excel Reader Excel Reader String to Date&Time Cross Joiner Rule-basedRow Filter Joiner Missing Value String Manipulation Sorter Column Filter String To Number

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: thagen
Created at: 2022-02-23
On NodePit since: 2022-02-24
Last update: 2024-04-30
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!