Copies column values from preceding rows into the current row. The node can be used to
- make a copy of the selected column and shift the cells I steps up (I = lag interval)
- make L copies of the selected column and shift the cells of each copy 1, 2, 3, ... L-1 steps up (L = lag = number of copies)
The option "Number of copies" (L) in this node is useful for time series prediction. If the rows are sorted in time increasing order, to apply a lag D to the selected column means to place D-1 past values of the column and the current value of the column on one row. The data table can then be used for time series prediction.
The lag interval option I (periodicity or seasonality) in this node is useful to compare values from the past to the current values. Again if the rows are sorted in time increasing order, to apply a lag interval I means to set aside on the same row the current value and the value occurring I steps before.
L and I can be combined to obtain L-1 copies of the selected column, each one shifted I, 2*I, 3*I, ... (L-1)*I steps backwards.
Options
Popular Successors
- Math Formula11 %
- Lag Column7 %
- Rule Engine7 %
- Date&Time Difference4 %
- Row Filter4 %
- Missing Value4 %
- Column Expressions4 %
- Loop End3 %
- Rule-based Row Filter3 %
Column Rename3 %- Sorter2 %
- Column Filter2 %
- Joiner2 %
- Partitioning2 %
- Linear Regression Learner2 %
- Column Aggregator1 %
- String Manipulation1 %
- GroupBy1 %
- Normalizer1 %
- Column Resorter< 1 %
- Java Snippet< 1 %
- Polynomial Regression Learner< 1 %
- Rule-based Row Splitter< 1 %
- Regression Predictor< 1 %
- RowID< 1 %
- Moving Average< 1 %
- Loop End (Column Append)< 1 %
- Math Formula (Multi Column)< 1 %
- Column Appender< 1 %
- Column Renamer< 1 %
- Excel Writer< 1 %
- Date&Time-based Row Filter< 1 %
- Linear Correlation< 1 %
- String to Number< 1 %
- Group Loop Start< 1 %
- Row Splitter< 1 %
- Concatenate< 1 %
Number To String< 1 %- String to Date&Time< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Date&Time Shift< 1 %
- CSV Writer< 1 %
- Create Collection Column< 1 %
- Simple Regression Tree Learner< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Reference Column Resorter< 1 %
- Table Row to Variable Loop Start< 1 %
Cell Splitter< 1 %- Duplicate Row Filter< 1 %
- Random Number Assigner< 1 %
- Table View (JavaScript)< 1 %
- Counter Generation< 1 %
- Shuffle< 1 %
- ARIMA Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
- Java Snippet (simple)< 1 %
- R Snippet< 1 %
- Moving Aggregator< 1 %
- Column List Loop Start< 1 %
- Column Comparator< 1 %
- Column Merger< 1 %
- Rank< 1 %
- Chunk Loop Start< 1 %
- Column Combiner< 1 %
- Keras Network Learner< 1 %
- Line Plot (JavaScript)< 1 %
- Date&Time to String< 1 %
- Table Manipulator< 1 %
- Extract Date&Time Fields< 1 %
- Unpivot< 1 %
- String Manipulation (Multi Column)< 1 %
Numeric Scorer< 1 %- Random Forest Predictor (Regression)< 1 %
- Table Transposer< 1 %
- Scatter Plot (JavaScript)< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- Scatter Plot (Plotly)< 1 %
- Table View< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Pivot< 1 %
- Value Counter< 1 %
Extract Date&Time Fields< 1 %- Recursive Loop Start< 1 %
- Python Script (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
- Java Edit Variable< 1 %
- Column Name Extractor< 1 %
Rank Correlation< 1 %- End IF< 1 %
Python Script (1⇒1)< 1 %- One to Many< 1 %
- Recursive Loop End< 1 %
- Decision Tree Learner< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Cross Joiner< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Set Operator< 1 %
- Date/Time Shift (legacy)< 1 %
Counting Loop Start< 1 %Scorer< 1 %- Numeric Scorer< 1 %
- SMOTE< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Regex Split< 1 %
- Rank Correlation< 1 %
- Line Plot (Plotly)< 1 %
- ARIMA Learner< 1 %
Loop End< 1 %- RProp MLP Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Cell Replacer< 1 %String To Number< 1 %- Reference Column Filter< 1 %
- Column Splitter< 1 %
- Target Shuffling< 1 %
- Scatter Plot (legacy)< 1 %
- Table to H2O< 1 %
- Java Snippet Row Filter< 1 %
- Value Filter (legacy)< 1 %
- Duration to Number< 1 %
- Window Loop Start< 1 %
- 2D/3D Scatterplot< 1 %
Table Writer< 1 %Recursive Loop Start (2 ports)< 1 %- Binner (Dictionary)< 1 %
- Number to Category (Apply)< 1 %
- Column Renamer (Dictionary)< 1 %
- Many to One< 1 %
- Reference Row Filter< 1 %
- Rule Engine (Dictionary)< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Interactive Histogram (legacy)< 1 %
- HeatMap (JFreeChart)< 1 %
- Table Row to Variable< 1 %
- Variable Condition Loop End< 1 %
- Conditional Box Plot (legacy)< 1 %
- String to Term< 1 %
- Tableau Writer< 1 %
- Bootstrap Sampling< 1 %
- Cell Splitter By Position< 1 %
- Column Selection Configuration< 1 %
- Line Plot< 1 %
- Inject Variables (Data)< 1 %
Database Table Selector< 1 %- Feature Selection Loop Start (1:1)< 1 %
Recursive Loop End< 1 %- k-Means< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Modify Date< 1 %
- Date Field Extractor (legacy)< 1 %
- String Similarity< 1 %
- ARIMA Visualization< 1 %
Recursive Loop Start< 1 %Variable Loop End< 1 %- PNN Predictor< 1 %
Gradient Boosted Trees Learner (Regression)< 1 %- Gradient Boosted Trees Predictor< 1 %
- Reference Column Splitter< 1 %
- Counting Loop Start< 1 %
- Scorer< 1 %
- Geo Distances< 1 %
- Logistic Regression Learner< 1 %
- Auto-Binner< 1 %
- Denormalizer< 1 %
- One Row to Many< 1 %
- Distance Matrix Calculate< 1 %
Excel Writer (XLS)< 1 %- Column Selection (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Table to R< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Time Difference (legacy)< 1 %
Generic Loop Start< 1 %- Cluster Assigner< 1 %
- SOTA Predictor< 1 %
- PCA Apply< 1 %
- Random Forest Predictor< 1 %
Concatenate (Optional in)< 1 %- Extract Missing Value Cause< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Many to One (PMML)< 1 %
- Numeric Outliers< 1 %
- Legacy Date&Time to Date&Time< 1 %
- PCA< 1 %
- Boosting Learner Loop End< 1 %
- Send to Power BI< 1 %
- Frequency Domain Features (FDF)< 1 %
- Split Collection Column< 1 %
CSV Writer< 1 %- DBSCAN< 1 %
- Decision Tree Predictor< 1 %
- Double to Integer< 1 %
- Time Series Generator< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- Scatter Plot (JFreeChart)< 1 %
Strings To Document< 1 %- JSON Path< 1 %
- Object Inserter< 1 %
- Window Slider< 1 %
- Duplicate Remover< 1 %
IF Switch (Flow Variable Value)< 1 %- Copy/Move Files (legacy)< 1 %
Table Column to Variable< 1 %Interval Loop Start< 1 %- Random Forest Learner< 1 %
- Filter Apply< 1 %
- Parallel Chunk End< 1 %
- Java Distance< 1 %
- Bar Chart (JavaScript)< 1 %
- Variable Expressions< 1 %
- Column Filter (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time to legacy Date&Time< 1 %
Column Distance< 1 %Extract Outer/InnerHTML< 1 %- Rule Engine Variable< 1 %
- Radar Plot Appender< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Image Writer (Table Column)< 1 %Database Writer< 1 %- X-Partitioner< 1 %
- Fuzzy Rule Predictor< 1 %
Regression Predictor< 1 %Tree Ensemble Predictor (Regression)< 1 %- Add Empty Rows< 1 %
- Category to Number< 1 %
Column Appender< 1 %Linear Correlation< 1 %- Edit Nominal Domain (Dictionary)< 1 %
- Edit Numeric Domain< 1 %
- Low Variance Filter< 1 %
- Round Double< 1 %
- Row Sampling< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
String Replace (Dictionary)< 1 %- Ungroup< 1 %
- IF Switch< 1 %
- String Distances< 1 %
DL Network Executor< 1 %PMML Predictor< 1 %- Math Formula (Variable)< 1 %
- Line Chart (JFreeChart)< 1 %
- Term Co-Occurrence Counter< 1 %
- Punctuation Erasure< 1 %
- JSON Diff< 1 %
- Align image< 1 %
- Image Converter< 1 %
Python Script (1⇒2)< 1 %- R View (Table)< 1 %
- Extract Time Window (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Lookup and Add Columns< 1 %
Loop End (3 ports)< 1 %Python Snippet< 1 %- Open in R< 1 %
- R Snippet (2:1)< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Variable to Table Row< 1 %Loop End (2 ports)< 1 %Linear Regression Learner< 1 %Logistic Regression Learner< 1 %- SVM Learner< 1 %
Random Forest Predictor (Regression)< 1 %Gradient Boosted Trees Learner< 1 %- Gradient Boosted Trees Learner (Regression)< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Case Converter< 1 %
- Column to Grid< 1 %
- Correlation Filter< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Row Splitter (Labs)< 1 %
- Subset Matcher< 1 %
- Normalizer (Apply)< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Number to String (PMML)< 1 %
String To Number (PMML)< 1 %- Rule-based Row Splitter (Dictionary)< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Histogram (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- SDF Writer< 1 %
- Parallel Chunk Start< 1 %
- Parameterized DB Query Reader< 1 %
- DB Writer< 1 %
- Numeric Distances< 1 %
- Matrix Distance< 1 %
- k-Medoids< 1 %
- Keras Network Executor< 1 %
- Table Indexer< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %Tableau Writer (Hyper)< 1 %- Term to String< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Text Output (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Labeling Arithmetic< 1 %
- Extract Duration Fields< 1 %
- Time Field Extractor (legacy)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Multiport Loop End< 1 %
- Benchmark End (Flow Variable)< 1 %
- Collection to String< 1 %
- Distance (2-D)< 1 %
- Signal Smoothing< 1 %
Recursive Loop End (2 ports)< 1 %- Logistic Regression Predictor< 1 %
- String to SVG< 1 %
- Row Filter (Labs)< 1 %
- Top k Row Filter< 1 %
- Ruleset Predictor< 1 %
- One-way ANOVA< 1 %
- Cache< 1 %
- Capture Workflow End< 1 %
- DB SQL Executor< 1 %
- TimeDelay Loop End< 1 %
- Similarity Search< 1 %
- Strings to Document< 1 %
- Weka Predictor (3.7)< 1 %
- Grayscale Reconstruction< 1 %
- Parameter Optimization Loop Start< 1 %
- Python View (legacy)< 1 %
Views
- This node has no views
Workflows
00_Python TestKNIME Hub- 00_Python TestKNIME Hub
- 00_Python TestKNIME Hub
- 01 Taxi Demand Prediction on Spark TrainingKNIME Hub
- 01 Time Series VisualizationKNIME Hub
- Show all 695 workflows
Links
- create date range from date columnby armingrudd on 2020-02-23forum.knime.com/p/82426
- Compare current and previous row in Java Knimeby HansS on 2020-06-27forum.knime.com/p/95408
- Deleting rows depending values of previous rowby tommy on 2021-02-04forum.knime.com/p/115027
- Create MTD data out of YTD valuesby AnotherFraudUser on 2020-05-20forum.knime.com/p/91989
- Calculation using value of previous rowby izaychik63 on 2020-04-08forum.knime.com/p/86908
- Show all 19 links
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.