First and last value in a row

KNIME Analytics Platform
1

Hi,
I’m trying to access the first and last value of column B that are assigned to a value in column A.
Here’s an example of how the table would look like:
example
For every number in A I need to access and compare the earliest and latest value, so for 1 it would be group A and C, for 2 - group A and B. How should I approach this?

2

Hello @Plant3000,

you need a GroupBy node with both first and last aggregation:

Welcome to KNIME Community!

Br,
Ivan

2 Likes
3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.