Find min and max timestamp for a subset of rows

[loris]

Hi,

i have a dataset like this :

what i need is an output like this :

I used a group by node to find min and max timestamp but if i do this, i only have one row with value ‘a’ with min timestamp : 10:00:00 and max timestamp : 13:30:00

Any idea ?

Thanks,
Loris

[HansS]

Hi @loris

I was thinking of something like this min_max_timestamp_subset_rows.knwf (48.9 KB) .
gr. Hans

[loris]

Hi @HansS,

This is exactly what i wanted to do

I installed “data generation” extension to use counter generation node, now i 've the output i wanted

Thanks for your help

Regards,
Loris

[morpheus]

Hi Loris,
what are the settings in your group by node?
If you set column value as group condition you should get for each unique entry a record.

BR