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)

Hi @zoe_knime , I had a look at your data and it’s not quite clear what exact logic you want to apply. [image] Though, I believe this approach will suffice: Loop per record [image] Group Loop Start Group loop start, each iteration processes another group of rows. The column(s) to group on need to be specified. The input data table is sorted based on the s… 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? [image] Lag Column: Allow negative lag Feedback & Ideas 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 grimacing 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… [image] Lag Column Copies column values from preceding rows into the current row. The node can be used to make a copy of the selected column and shift the cells I steps up ( I &#… Here is the possible solution: [image] [image] 79978 - Conditionally add Column – mwiegand Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Best Mike

Adding new column based on another

KNIME Analytics Platform

mwiegand June 2, 2024, 6:32am 2

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:

Loop per record

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?

Here is the possible solution:

Best
Mike

2 Likes