Icon

Challenge-5 justknimeit 5

Reference Table Creation Based on the Date Range in the Contract_Dates_Table Extract contract_dates_table.xlsxConvert data typeto dateModify dateformatStart the loopprocess by passingeach contract_dateas a variableEnd LoopRemove False values("NA")Sort date in Ascending orderExtract theyears fromthe datesRemove thecontact_datescolumnRemoveduplicate yearsUse the featuresof this node to create the "key", "start" and "end" columnsRemove the"Year" columnConvert the "Start" and "End" columns to date datatypeTidyingup the RowIDsResult Table Presentationrule to compare contract dates Excel Reader String to Date&Time String Replacer Table Row ToVariable Loop Start Loop End Row Filter Sorter Extract Date&TimeFields Column Filter DuplicateRow Filter Column Expressions Column Filter String to Date&Time RowID Joiner Rule Engine Reference Table Creation Based on the Date Range in the Contract_Dates_Table Extract contract_dates_table.xlsxConvert data typeto dateModify dateformatStart the loopprocess by passingeach contract_dateas a variableEnd LoopRemove False values("NA")Sort date in Ascending orderExtract theyears fromthe datesRemove thecontact_datescolumnRemoveduplicate yearsUse the featuresof this node to create the "key", "start" and "end" columnsRemove the"Year" columnConvert the "Start" and "End" columns to date datatypeTidyingup the RowIDsResult Table Presentationrule to compare contract datesExcel Reader String to Date&Time String Replacer Table Row ToVariable Loop Start Loop End Row Filter Sorter Extract Date&TimeFields Column Filter DuplicateRow Filter Column Expressions Column Filter String to Date&Time RowID Joiner Rule Engine

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: demol
Created at: 2022-02-23
On NodePit since: 2022-02-25
Last update: 2024-11-21
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!