lag column -1

[aurelienchauvin]

hi i would like to lag a row to the top and not to the bottom. I tried -1 but it doesn’t work.
ty for help

[takbb]

Hi @aurelienchauvin, the lag node only works in one direction so to “reverse” the lag operation, what I do is first sort the table in reverse order. (if there is currently no suitable ordered key, then first of all add a sequential key column using a Counter Generation node and sort descending using the counter).

After sorting, perform the Lag Node as before and then sort the table back to the original order.

[gonhaddock]

Hello @aurelienchauvin
You can take a look into to the following topic:

Shift Row Up

Hello Dear All, I need to shift the rows up but don’t know how to do. To shift down we have Lag column node but is there anything to shift the rows up? thanks in advance =) [image]

‘Column Expressions’ would be the alternative node to perform this task with the offset() function. With checked ‘Enable multi-row access’ and ‘Use null’ (?) for prior. after first last row…

column("target_column", 1)

BR

[aurelienchauvin]

thank you it’s a good idea but i don’t find counter generation.

[HansS]

Hi @aurelienchauvin

Drag and drop the node from the KNIME Hub

And it wil be installed.

Or use the Math Formula node:

gr. Hans

[aurelienchauvin]

thank you for answer, I found this solution.
regards