This content has been marked as final. Show 6 replies
I have a problem with a selection in my script.
My original table looks like this:
I would like to find the lowest value for every ID2 and also show the corresponding ID1, so I made the following script:
load * INLINE [
ID1, ID2, VALUE,
1, 10, 4
1, 10, 7
3, 33, 67
3, 33, 5
MIN(VALUE) AS VALUE
RESIDENT TABLE1 GROUP BY ID2;
The result is:
This is not as desired, ID1 is missing in the line where there is no value.
Can someone please tell me why ID1 is missing (I expected it to be 2) and how I can solve this?