Does anyone know how I can move an entire column up by 1 in Knime? Thanks

Assuming that you’re talking about rows, you can use a Moving Aggregator node. [image] Lag Column with Negative value? KNIME Analytics Platform Hi there! You are right! Using Moving Aggregation you can simulate negative lag interval in Lag Column node. Window type is Forward, window length-1 determines the lag interval and aggregation is Last on lagging column. Additionally there is another way using just a bit of filtering where number of excluded rows determines the lag interval wink [NegLagColumn] Workflow is attached so check it out and if any questions feel free to ask. 2019_04_03_ReverseLagColumnOption.knwf (16.2 KB) Rega…

Column Expression is another possibility: [image] [image]

Thanks for your help. Howerver I do not have column expressions. Only expressions and it is different from yours. [image]

Hi @maya29 If you are able to install extensions, the Column Expressions node can be installed by dragging this from the hub: [image] Column Expressions This node provides the possibility to append an arbitrary number of columns or modify existing columns using expressions. For each column that shall be appende… In the (“new”) Expression node, it can be achieved similarly: with $["column2",1] [image]

I am unable to enter a -1 for the Window length

Hello @maya29 Alternatively as @elsamuel suggested; you can use ‘Moving Aggregation’ as a low code solution for shifting rows up and down, customizing shifting range. Take a look into this topic: [image] Shift Row Up KNIME Analytics Platform Hello @kubra_08 The low code node for this task is Moving Aggregation . This is an underrated node from my opinion, as it can deliver many different functions. It can also perform ‘lag function’ with ‘Backward’ and ‘First’ Aggregation options. [image] The alternative way to proceed would be ‘Column Expressions’ node, but will require some coding. BR BR

I like that @elsamuel and @gonhaddock . I had never thought about using Moving Aggregator as a (more powerful) lag column node! Don’t know why, but just never thought about it. For the purposes of shifting the one column “in situ”, it’s worth pointing out (using the screenshot from @gonhaddock 's post), also ticking “Remove aggregation columns” and then setting “Column naming” to “Keep original name(s)”

This worked great and helped me with what I wanted to achieve. Thanks alot! I am just getting back into using KNIME again. I initially started in 2019 but haven`t been using it since then. I am trying to use it again now. Thanks again!

for some reason that pushes it too far ahead. as in down. I wanted to move it up. And takbb suggestion helped me do just that. But thanks again!

Move entire column up by 1

KNIME Analytics Platform

elsamuel November 13, 2024, 1:04pm 2

Assuming that you’re talking about rows, you can use a Moving Aggregator node.