I have a sorting problem of my data. I would like to find the lowest datapoint from each of my id's.
My data looks like:
4 ID 1
2 ID 1
3 ID 1
5 ID 2
3 ID 2
2 ID 2
1 ID 3
2 ID 3
3 ID 3
What i wish for is
2 ID 1
2 ID 2
1 ID 3
I have a sorting problem of my data. I would like to find the lowest datapoint from each of my id's.
My data looks like:
4 ID 1
2 ID 1
3 ID 1
5 ID 2
3 ID 2
2 ID 2
1 ID 3
2 ID 3
3 ID 3
What i wish for is
2 ID 1
2 ID 2
1 ID 3
Hi,
Assuimng your data is splitted into two columns: id, datapoint
Use the GroupBy node, group on the "id" column and aggregate the Minimum value for "datapoint"
Then you may use the "Sorter" node to reorder your results as required.
Moran