Find min and max timestamp for a subset of rows

Hi,

i have a dataset like this :

what i need is an output like this :

output

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

Hi @loris

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

2 Likes

Hi @HansS,

This is exactly what i wanted to do :grinning:

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

Thanks for your help :wink:

Regards,
Loris

3 Likes

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

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