Icon

2020_​07_​30_​Filter_​Based_​on_​Week_​Number

Filter based on Week Number
Filter based on Week NumberThis workflow demonstrates how to filter based on week number which is located in file input name. Forum link: https://forum.knime.com/t/retrieve-date-from-filename/25533 Case 1: Week numbers from KNIME matche your week numbers Case 2: Week number from KNIME doesn't match your week number external file with Week Numbers and Dates is used. Input dataCreate flow variable from path/urlExtract Week numberFilter based on week number from fileGet date as flow variableSample data set with datesFilter based on start weekInput dataCreate flow variable from path/urlExtract Week numberFilter based on week number from fileSample data with datesExtract week numberExternal file with Week number and start dateAdd time00:00Excel Reader (XLS) String Manipulation(Variable) Row Filter Table Rowto Variable Create Date&TimeRange Date&Time-basedRow Filter Excel Reader (XLS) String Manipulation(Variable) Row Filter Create Date&TimeRange Extract Date&TimeFields File Reader Modify Time Filter based on Week NumberThis workflow demonstrates how to filter based on week number which is located in file input name. Forum link: https://forum.knime.com/t/retrieve-date-from-filename/25533 Case 1: Week numbers from KNIME matche your week numbers Case 2: Week number from KNIME doesn't match your week number external file with Week Numbers and Dates is used. Input dataCreate flow variable from path/urlExtract Week numberFilter based on week number from fileGet date as flow variableSample data set with datesFilter based on start weekInput dataCreate flow variable from path/urlExtract Week numberFilter based on week number from fileSample data with datesExtract week numberExternal file with Week number and start dateAdd time00:00Excel Reader (XLS) String Manipulation(Variable) Row Filter Table Rowto Variable Create Date&TimeRange Date&Time-basedRow Filter Excel Reader (XLS) String Manipulation(Variable) Row Filter Create Date&TimeRange Extract Date&TimeFields File Reader Modify Time

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: Johnny
Created at: 2019-01-03
On NodePit since: 2020-07-31
Last update: 2024-04-18
Created with KNIME version: v4.2.0
Tags: Date&TimeWeek NumberFiltering

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!