Group by function

[Anonymous]

Hi gurus,

I have to use group by for filtering Max values in my data set but there is a weird thing happening. I was wondering what

Group by

function is doing? Here is my dataset and the job I need to do:

Group by Ticket 
New column name:                                Operation:                                   Column:
Max                                              Maximum                                      Max

and the second situation when I have Qty as one of my column:

First I merged Ticket&Qty with comma seperator and then I used Group by: Ticket&Qty and Maximum by Max cloumn.

The final result is so different:

in the first situation I have 166 rows after grouping them and in second situation I have 205 rows!

My question is why there is such a big descripancy and what exactly is Group by function does?

Thanks

[parry2k · Accepted solution]

@Anonymous it is gong to return maximum value of unique value of group by columns

in 1st case, take unique ticket number and give the maximum qty

in 2nd case, take unique of ticket number & qty (concatenated file) and give the max qty and I expect more rows in 2nd case depending on data.

here is example

Ticket Qty

1       10

1       20

2       40

2       50

2       50

In first case, i will get two rows

Ticket    Max Qty

1             20 

2             50

in 2nd case I will get 4 rows

Ticket,Qty         Max Qty

1,10                    10

1,20                    20

2,40                    40

2,50                    50