Get 2 min values

[bharatkishore]

HI All,

I have  the following columns in script:

     Equipment,

     [Part Group],

     Key_EMS,

     Calendar,

     Age_Final,

      Quantity

Need to get the output like below:

Equipment	Part Group	Key_EMS	Calendar	Age_Final	Quantity
E1	P1	Key2	2013-01	3	0
E1	P1	Key4	2013-01	5	1
E2	P1	Key7	2013-01	22	1
E2	P1	Key8	2013-01	15	0
E3	P2	Key10	2013-02	5	1
E3	P2	Key11	2013-02	5	0

And need to do sum of quantity and  group by should be on following columns i.e Equipment,Part Group,Calendar

Please let me know if you need anything more.

Attached excel for reference:

Thanks,

Bharat

[vamsee]

If your Group by is on Equipment,Part Group & Calendar, then can you please explain why the Quantity value differed for the first 2 lines in your expected output.

E1	P1	Key2	2013-01	3	0
E1	P1	Key4	2013-01	5	1

[timpoismans]

Please refrain from creating multiple threads about the same issue.

The following threads already exist:

Rank in script

Need to get 2 ages

Creating multiple threads won't get your issue solved faster.

[timpoismans]

As explained in his other two threads, he wants the two lowest values of [Age_Final] per Equipment, [Part Group], Calendar.

So the Sum(Quantity) is actually grouped by Equipment, [Part Group], Calendar and [Age_Final]