to move the column up (specified ID range)

Hi;
I want to move upwards according to ROW ID. (such as cut and paste)
match the data in the other columns and the data in the row I want to move
how can I do it ?

image

Move one cell up the end column without losing the data in other columns. according to the specified ROWID

image

  1. Duplicate shifting column say by Rule Engine.
  2. shift column by Lag Column Node.
  3. Use Rule Engine to replace value for specific rowID’s
  4. Get rid of added column by Column Filter.
1 Like

thanks for the answer. I wonder if you could add a sample workflow.

What about something like this? Afterward just use the Column Filter and/or Column Rename nodes to clean up as needed.

2018-12-14%2013_03_38-KNIME%20Analytics%20Platform

LookAheadShiftExample.knwf (7.0 KB)

2018-12-14%2013_03_47-Moving%20average%20values%20-%204_33%20-%20Moving%20Aggregation%20(Look%20ahead)

Or maybe this is too simple for what you need, if you must include RowIDs. Something to think about, anyway.

4 Likes

thanks for the answer.
I need to get a cell up in the entire column then I’ll delete unnecessary lines.
But I couldn’t figure out how to move the entire column without affecting the others. (I have to remove the peak at the top)

The sample you sent will definitely work. So many thanks :slight_smile: I can solve this method.

1 Like

2 Likes

wow thank you, I also needed exactly what you have posted! Great solution!

3 Likes