Extracts all rows where the time value of the selected column lies within a given time window from the input. The time window is specified by a start and end date (and time).
Options
Popular Predecessors
Extract Date&Time Fields6 %Row Splitter (deprecated)6 %- Mask Date/Time (legacy)4 %
- Column Resorter3 %
- Reference Row Filter3 %
- Date&Time Input (legacy)2 %
Excel Reader (XLS)2 %Date Input (legacy)2 %- Extract Time Window (legacy)2 %
Row Filter (deprecated)2 %- Java Snippet2 %
Joiner2 %- String Manipulation1 %
Excel Reader (XLS)1 %- Time Difference (legacy)1 %
Database Connection Table Reader1 %- Concatenate1 %
- Nominal Value Row Filter1 %
- Group Loop Start< 1 %
Cell Splitter< 1 %Number To String< 1 %- Column Aggregator< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- String Replacer< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Date&Time to legacy Date&Time< 1 %
- String to Date&Time< 1 %
- Date/Time Shift (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- String to Number< 1 %
- Create Date&Time Range< 1 %
- Cell Splitter< 1 %
- Excel Reader< 1 %
- Date&Time Part Extractor< 1 %
- DB Reader< 1 %
- Joiner< 1 %
CSV Reader< 1 %- Table Creator< 1 %
Concatenate (Optional in)< 1 %- Double to Integer< 1 %
- Pivot< 1 %
- Sorter< 1 %
Merge Variables< 1 %- Date&Time-based Row Filter< 1 %
Table Row to Variable< 1 %Table Reader< 1 %- One to Many< 1 %
- Equal Size Sampling< 1 %
Column Rename< 1 %- Rule Engine< 1 %
XLS Reader< 1 %- Date&Time Difference< 1 %
- Date&Time to String< 1 %
File Meta Info< 1 %- URI Port to Variable< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %File Reader< 1 %- Java Edit Variable< 1 %
- Auto-Binner< 1 %
Cell Replacer< 1 %String To Number< 1 %- Column Merger< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Missing Value< 1 %
- Column Splitter< 1 %
- Rule Engine Variable< 1 %
- Cache< 1 %
- Global Timer Info< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- Preset Date/Time (legacy)< 1 %
- Twitter Search< 1 %
- K Nearest Neighbor< 1 %
- Column Auto Type Cast< 1 %
- Filter Apply< 1 %
- Nominal Value Row Splitter< 1 %
- RowID< 1 %
Excel Reader (XLS)< 1 %- Column Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time Shift< 1 %
- File Reader< 1 %
- Crosstab< 1 %
- Files/Folders Meta Info< 1 %
- TIBCO Spotfire File Reader< 1 %
- Copy/Move Files (legacy)< 1 %
- Inject Variables (Data)< 1 %
CSV Writer< 1 %Database Reader< 1 %- Extract System Properties< 1 %
Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Loop End< 1 %Counting Loop Start< 1 %PCA< 1 %- Linear Regression Learner< 1 %
- Numeric Binner< 1 %
- Column Combiner< 1 %
Column Appender< 1 %- Lag Column< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Row Sampling< 1 %
- Value Counter< 1 %
- End IF< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Size Manager< 1 %
- One Row to Many< 1 %
- TimeDelay Loop Start< 1 %
- Math Formula< 1 %
- Math Formula (Variable)< 1 %
- Java Snippet (simple)< 1 %
Value Filter QuickForm (legacy)< 1 %- Legacy Date&Time to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Time to String (legacy)< 1 %
XML Reader< 1 %- Window Slider< 1 %
- String to URI< 1 %
- Breakpoint< 1 %
Variable to Table Row< 1 %Database Looping< 1 %Interval Loop Start< 1 %- Column List Loop Start< 1 %
Generic Loop Start< 1 %Recursive Loop Start< 1 %- Fuzzy Rule Learner< 1 %
- Column Comparator< 1 %
- Category to Number< 1 %
- Normalizer (PMML)< 1 %
- Number Rounder< 1 %
- Extract Table Spec< 1 %
- Color Manager< 1 %
- TimeDelay Loop End< 1 %
- Ruby Script< 1 %
- Geo-Coordinate Row Filter< 1 %
Read Excel Sheet Names (XLS)< 1 %- Date&Time Configuration< 1 %
Python Script (1⇒1)< 1 %- Modify Date< 1 %
- RDKit Count-Based Fingerprint< 1 %
- List Remote Files (legacy)< 1 %
- CSV Reader< 1 %
- Row Filter (Labs)< 1 %
- Data Explorer< 1 %
- Modify Time Zone< 1 %
Views
- This node has no views
Workflows
01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub- 01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub
- 01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub
- 02_Time_Series_AR_TrainingKNIME Hub
- 03_Time_Series_AR_DeploymentKNIME Hub
- Show all 6 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.