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 either an end date (and time), a duration or a numerical value combined with a granularity.
Options
Column Selection
DateTime Selection
Popular Successors
- GroupBy11 %
- Joiner9 %
Row Filter (deprecated)7 %- Excel Writer5 %
- Column Filter4 %
- Concatenate4 %
- Rule-based Row Filter4 %
- Rule Engine2 %
- Pivot2 %
- Date&Time Part Extractor2 %
- Date&Time-based Row Filter2 %
- Duplicate Row Filter2 %
- String Manipulation2 %
- Date&Time to String2 %
- Reference Row Filter2 %
- Nominal Value Row Filter2 %
Row Splitter (deprecated)1 %- Column Expressions1 %
- CSV Writer1 %
- Sorter1 %
- Constant Value Column1 %
- Date&Time Difference1 %
- Math Formula< 1 %
- Rule-based Row Splitter< 1 %
- String to Number< 1 %
- Missing Value< 1 %
Concatenate (Optional in)< 1 %- Date&Time Shift< 1 %
- Group Loop Start< 1 %
- Cell Splitter< 1 %
- Table Row to Variable Loop Start< 1 %
- Loop End< 1 %
- Column Resorter< 1 %
- Table Manipulator< 1 %
- String to Date&Time< 1 %
- Table Writer< 1 %
- Reference Row Splitter< 1 %
- Domain Calculator< 1 %
- DB Writer< 1 %
- Modify Date< 1 %
- Value Counter< 1 %
- Ungroup< 1 %
- Nominal Value Row Splitter< 1 %
- Line Plot (JavaScript)< 1 %
- Number to String< 1 %
- Cross Joiner< 1 %
- Row Filter (Labs)< 1 %
- Partitioning< 1 %
- Column Renamer< 1 %
- Google Sheets Updater< 1 %
Number To String< 1 %- Parquet Writer< 1 %
- Rank< 1 %
- Empty Table Switch< 1 %
- DB Insert< 1 %
CSV Writer< 1 %- Logistic Regression Learner< 1 %
- Table Difference Finder< 1 %
- Value Lookup< 1 %
- String Replacer< 1 %
- Send to Tableau Server< 1 %
Cell Splitter< 1 %- Date&Time to legacy Date&Time< 1 %
Cell Replacer< 1 %- Column Combiner< 1 %
Column Appender< 1 %- Row Splitter (Labs)< 1 %
Joiner< 1 %- RowID< 1 %
- Numeric Row Splitter< 1 %
- Line Plot< 1 %
- Chunk Loop Start< 1 %
- Missing Value (Apply)< 1 %
- Set Operator< 1 %
- Path to String< 1 %
- Table Row to Variable< 1 %
- Java Snippet< 1 %
- Case Converter< 1 %
- Column Aggregator< 1 %
- Number Rounder< 1 %
- Top k Row Filter< 1 %
- DB Loader< 1 %
- Math Formula (Multi Column)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Data to Report (BIRT)< 1 %
- ARIMA Visualization< 1 %
- String to URI< 1 %
- Variable Loop End< 1 %
Linear Correlation< 1 %Parquet Writer< 1 %- Parameterized DB Query Reader< 1 %
Excel Writer (XLS)< 1 %Tableau Writer (TDE)< 1 %- JSON Path< 1 %
- Modify Time< 1 %
Database Looping< 1 %- Linear Regression Learner< 1 %
- Lag Column< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
- CASE Switch Start< 1 %
- Parallel Chunk Start< 1 %
- DB Delete (Table)< 1 %
- Table Editor (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Modify Time Zone< 1 %
- Random Forest Predictor (Regression)< 1 %
- Column Comparator< 1 %
- Row Aggregator< 1 %
- Rule Engine (Dictionary)< 1 %
- One-way ANOVA< 1 %
- Extract Table Spec< 1 %
- DB Merge< 1 %
- Java Snippet Row Filter< 1 %
- Tableau Writer< 1 %
- TF< 1 %
- Delete Files/Folders (Table)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Value Selection Widget< 1 %
- Python Predictor (legacy)< 1 %
- ARIMA Learner< 1 %
- Variable to Table Column< 1 %
Table Row To Variable Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %- RProp MLP Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Learner (Regression)< 1 %
- Simple Regression Tree Predictor< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Linear Correlation< 1 %
- Reference Column Filter< 1 %
- Subset Matcher< 1 %
- Normalizer< 1 %
- Table Transposer< 1 %
- Statistics< 1 %
- Histogram (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Color Manager< 1 %
- Bar Chart< 1 %
- Table View< 1 %
- Parallel Chunk End< 1 %
- DB Reader< 1 %
- Keras Network Learner< 1 %
- Association Rule Learner (Borgelt)< 1 %
Send to Tableau Server (Hyper)< 1 %- Nominal Row Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Python Script (legacy)< 1 %
- Python View (legacy)< 1 %
- Duration to Number< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Aggregator< 1 %
- Column to XML< 1 %
Regex Extractor< 1 %- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
Table Writer< 1 %Loop End< 1 %- Column List Loop Start< 1 %
- X-Partitioner< 1 %
- Regression Predictor< 1 %
- Numeric Scorer< 1 %
Random Forest Learner< 1 %- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Correlation Filter< 1 %
- Table Validator (Reference)< 1 %
- CAIM Binner< 1 %
- Double to Integer< 1 %
- Equal Size Sampling< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Column Filter (PMML)< 1 %
- Reference Column Resorter< 1 %
- String Splitter (Regex)< 1 %
Column Rename< 1 %- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Line Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Pie Chart< 1 %
- Statistics View< 1 %
- Workflow Executor< 1 %
- DB Table Creator< 1 %
- Counter Generation< 1 %
- Line Plot (Plotly)< 1 %
- Scatter Plot (Plotly)< 1 %
- External Tool< 1 %
- Line Chart (JFreeChart)< 1 %
- OSM Map View< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Writer (XLS)< 1 %- Excel Reader< 1 %
- SMB Connector< 1 %
- Java Snippet (simple)< 1 %
- Strings to Document< 1 %
- String to Path< 1 %
- Google Sheets Writer< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- Python Learner (legacy)< 1 %
- Add Table to R< 1 %
- R Snippet< 1 %
- R View (Table)< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Window Loop Start< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- Table to HTML String< 1 %
Loop End (Upto 4 ports)< 1 %- Missing to Empty Collection< 1 %
- ARIMA Predictor< 1 %
- Find MIME-Type< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %- Extract Missing Value Cause< 1 %
- Normalizer (Apply)< 1 %
- Create Temp Dir (legacy)< 1 %
- Bar Chart (JavaScript)< 1 %
Excel Sheet Appender (XLS)< 1 %- Transfer Files (Table)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Extract Time Window (legacy)< 1 %
- Fast Fourier Transform (FFT)< 1 %
- XLS Control Table Generator< 1 %
- Extract Variables (Data)< 1 %
Database Writer< 1 %Generic Loop Start< 1 %- MultiLayerPerceptron Predictor< 1 %
Regression Predictor< 1 %- SMOTE< 1 %
Gradient Boosted Trees Learner (Regression)< 1 %- Random Forest Learner< 1 %
- Random Forest Predictor< 1 %
- String Manipulation (Variable)< 1 %
- Box Plot (legacy)< 1 %
Statistics< 1 %- Random Number Assigner< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %- Value Selection (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- Table to JSON< 1 %
- Duration to String< 1 %
- Extract Duration Fields< 1 %
- Time Field Extractor (legacy)< 1 %
XGBoost Tree Ensemble Learner (Regression)< 1 %- Table to Event Log< 1 %
- URL Domain Extractor< 1 %
- Write To Excel Template (deprecated)< 1 %
- Create Collection Column< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Loop End (2 ports)< 1 %- Decision Tree Predictor< 1 %
- Association Rule Learner< 1 %
Gradient Boosted Trees Learner< 1 %String To Number< 1 %- One to Many< 1 %
- Table Validator< 1 %
- Low Variance Filter< 1 %
- Denormalizer< 1 %
Normalizer< 1 %- Normalizer (PMML)< 1 %
- Independent groups t-test< 1 %
- Timer Info< 1 %
- Interactive Pie chart (legacy)< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Capture Workflow End< 1 %
- DB Query Reader< 1 %
DB Table Creator< 1 %- Conditional Label Assigner< 1 %
- Similarity Search< 1 %
- 2D Density Plot (Plotly)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Google Sheets Appender< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Container Output (Table)< 1 %
- String to JSON< 1 %
- Ultrametric Contour Map< 1 %
- Object Inserter< 1 %
Python Script (1⇒1)< 1 %- Create Date&Time Range< 1 %
XGBoost Tree Ensemble Learner< 1 %- XGBoost Predictor (Regression)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- HTTP Retriever< 1 %
- Window Slider< 1 %
- TIBCO Spotfire File Writer< 1 %
IF Switch (Flow Variable Value)< 1 %- Table Row To Variable Run-for-time Loop Start< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
PDB Connector Custom Report< 1 %- Envelope Function< 1 %
- Number Formatter< 1 %
- Range Filter< 1 %
- Matlab Snippet< 1 %
- R Snippet< 1 %
- Fix Column Names< 1 %
- 2D/3D Scatterplot< 1 %
- Entropy Uncertainty Scorer< 1 %
Element Selector< 1 %- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- URL to File Path< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %CSV Reader< 1 %Database Reader< 1 %Database Update< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %Recursive Loop End< 1 %- Recursive Loop Start< 1 %
Recursive Loop Start< 1 %- Naive Bayes Learner< 1 %
- Naive Bayes Predictor< 1 %
- Fuzzy Rule Learner< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- k-Means< 1 %
- DBSCAN< 1 %
- Decision Tree Learner< 1 %
- K Nearest Neighbor< 1 %
PCA Compute< 1 %- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
- Scorer< 1 %
Numeric Scorer< 1 %- PCA Apply< 1 %
Gradient Boosted Trees Predictor< 1 %- PMML Gradient Boosted Trees Predictor< 1 %
- Tree Ensemble Learner< 1 %
- Simple Regression Tree Learner< 1 %
- Category to Number< 1 %
- Column Name Extractor< 1 %
- Edit Numeric Domain< 1 %
Column Filter< 1 %Number To String (PMML)< 1 %- String to Number (PMML)< 1 %
- Shuffle< 1 %
String Replace (Dictionary)< 1 %- Rule Engine Variable< 1 %
- Ruleset Editor< 1 %
Rank Correlation< 1 %- Rank Correlation< 1 %
- Numeric Outliers (Apply)< 1 %
CASE Switch Data (End)< 1 %- Cache< 1 %
Merge Variables< 1 %- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- HiLite Table (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Shape Manager< 1 %
- Table to Spark< 1 %
PostgreSQL Connector< 1 %- DB Connection Closer< 1 %
DB Loader< 1 %- DB Row Filter< 1 %
- DB Row Sampling< 1 %
- Gaussian Distributed Assigner< 1 %
- Time Series Generator< 1 %
- Numeric Distances< 1 %
- k-Medoids< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Boosting Learner Loop Start< 1 %
- Variable Expressions< 1 %
Table to HTML< 1 %- Table to PDF (legacy)< 1 %
Table to PDF< 1 %- Table to H2O< 1 %
- Math Formula (Variable)< 1 %
Send to Power BI< 1 %TIBCO File Writer< 1 %- Spark Line Appender< 1 %
Tableau Writer (Hyper)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Number Filter< 1 %
- Punctuation Erasure< 1 %
- Dictionary Tagger< 1 %
POS tagger< 1 %- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- Unique Term Extractor< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Weka Predictor (3.7)< 1 %
- List Files/Folders< 1 %
- Path to URI< 1 %
- Heatmap (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Columns to JSON< 1 %
- JSON to Table< 1 %
- Don't Save Start< 1 %
- Image Viewer< 1 %
- MongoDB Update< 1 %
- Node Name Filter< 1 %
Python Script (2⇒1)< 1 %- R Predictor< 1 %
- GET Request< 1 %
- POST Request< 1 %
- String to Duration< 1 %
- Date/Time Shift (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Country Extractor< 1 %
- String to XML< 1 %
- Web Page Content Extractor< 1 %
- Geo Distances< 1 %
- HTML Parser< 1 %
- Start WebDriver< 1 %
Views
- This node has no views
Workflows
0. Lubes_Sales_Pred-ModelNodePit Space- 0. Lubes_Sales_Pred-ModelNodePit Space
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 0009582-6KNIME Hub
- 01_03_Supply_Chain_Dashboards_Cycle_TimeKNIME Hub
- Show all 591 workflows
Links
- Delete rows and continue with new tableby armingrudd on 2019-06-28forum.knime.com/p/63651
- Filtering a table effectively by a certain dateby armingrudd on 2019-05-16forum.knime.com/p/60648
- Dynamic Time Horizonby armingrudd on 2019-06-27forum.knime.com/p/63232
- Historical ruing 30 day windowby izaychik63 on 2020-02-05forum.knime.com/p/80712
- Moving Average for Only Most Recent Dateby armingrudd on 2019-10-31forum.knime.com/p/73666
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.