Adding new column based on another

[zoe_knime]

Hello,

I am trying to add a new column to my dataset that is based on the following row in the dataset. I have attached an example of the input data I’m working with and the desired output data for this example.

I have a series of ‘from’ data that is listed in a sequence based on record numbers. I want to add a new column called ‘to’ that takes the ‘from’ ID from the following record in the sequence and adds it to the preceeding row.

Any help would be really appreciated.

Thanks!
Example Sequence Link.knwf (8.2 KB)

[mwiegand]

Hi @zoe_knime,

I had a look at your data and it’s not quite clear what exact logic you want to apply.

Though, I believe this approach will suffice:

1. Loop per record

Group Loop Start

2. Use Lag column to shift the data
   Note: Sadly his node dos not support a negative value but I’ve got a fallback. Maybe you vote for this feature request?

Lag Column: Allow negative lag

Hi, maybe I recall it wrong but didn’t the Lag Column allow to enter negative values which was also requested and close many years ago? If true, this is a serious bug of the modern UI which sneaked into the Classic UI since 5.x This feature request, which I noticed I commented to back in 2019, got closed as well. So I assume this feature request was never integrated but why have the requests been closed? The workarounds are significantly more complex and providing an out of the b…

Lag Column

Here is the possible solution:

79978 - Conditionally add Column – mwiegand

Best
Mike

[zoe_knime]

This is perfect, thanks so much Mike! and thank you for being kind with your response.