Move entire column up by 1

[maya29]

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

[elsamuel]

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

Lag Column with Negative value?

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 [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…

[takbb]

Column Expression is another possibility:

[maya29]

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

[takbb]

Hi @maya29

If you are able to install extensions, the Column Expressions node can be installed by dragging this from the hub:

Column Expressions

In the (“new”) Expression node, it can be achieved similarly:

with

$["column2",1]

[maya29]

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

[gonhaddock]

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:

Shift Row Up

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

[elsamuel]

Use 2 for window length

[takbb]

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)”

[maya29]

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!

[maya29]

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!