{"title":"Lag Column","nodeType":"Manipulator","id":"*RurwVi1VODgLDTQP","factoryName":"org.knime.base.node.preproc.columnlag.LagColumnNodeFactory","factoryId":"org.knime.base.node.preproc.columnlag.LagColumnNodeFactory","path":["Manipulation","Column","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

Copies column values from preceding rows into the current row. The node can be used to

  1. make a copy of the selected column and shift the cells I steps up ( I = lag interval)
  2. 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)
\n \n

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.

\n \n

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.

\n \n

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.

\n \n ","shortDescription":"Copies column values from preceding rows into the current row.","keywords":["Copy column","Shift","Offset","Previous"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NTNDQTZGMzI4N0JEMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RTc3QkMxNUU4NzlBMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDNDk1MkZCMTE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpDNDk1MkZCMjE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PpmRUj4AAAB/SURBVHjaYhAQEPiPDBgYGDD4DEgAIoQQY2KgEAwDA1hIUQwNQBQ2SQYwMjL+R2eT6gUudDOZSPTCdyBmhLIZSfICyM9AZyvANMPYLH/+/CHH/whx9KSKSz9I3cfJ1kDb/8EFBfKOg73AiBw9OGzHnw7wKaB5SiTFaqz+BAgwAOauR29ZwHfNAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input","description":"Input data"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output","description":"Input data with additional columns copying the values from preceding rows."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Column to lag","description":"The column to be lagged.","optional":false},{"name":"Number of copies","description":"L= defines how many lagged column copies to create.","optional":false},{"name":"Lag per copy","description":"I= lag interval (sometimes also called periodicity or seasonality), defines how many rows to shift per column copy.","optional":false},{"name":"Drop incomplete rows at the top of the table","description":"If selected, the first rows from the input table are omitted in the output so that the lag output column(s) is not missing (unless the reference data is missing).","optional":false},{"name":"Drop incomplete rows at the bottom of the table","description":"If selected the rows containing the lagged values of the last real data row are omitted (no artificial new rows). Otherwise new rows are added, which contain missing values in all columns but the new lag output.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:47dff44b-850b-48fe-b19a-ae20b3c692bd","user":"carlosenrique84","date":"2025-11-30T19:39:14+00:00"}],"kudosCount":1,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.1488162344983089},{"id":"*RurwVi1VODgLDTQP","factoryName":"org.knime.base.node.preproc.columnlag.LagColumnNodeFactory","probability":0.08680947012401354},{"id":"*zpGPAjDyExkFL2HB","factoryName":"org.knime.base.node.rules.engine.RuleEngineNodeFactory","probability":0.05411499436302142},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.0496054114994363},{"id":"*uVmaGQkzUOFCTqUe","factoryName":"org.knime.base.node.preproc.pmml.missingval.compute.MissingValueHandlerNodeFactory","probability":0.04735062006764374},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.03720405862457723},{"id":"*gwwIZ5c5EYsJErci","factoryName":"org.knime.base.node.preproc.sorter.SorterNodeFactory","probability":0.03269447576099211},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.030439684329199548},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.02593010146561443},{"id":"*T0AhxSe0Yi42rQK8","factoryName":"org.knime.base.node.preproc.partition.PartitionNodeFactory","probability":0.02480270574971815}]}