How to sort and pick values.

Thu, 25 Dec 2014 16:34:18 GMT

Hi guys,

I got one data set like following:

first second Third

01/12/2014 1 12

01/12/2014 3 23

01/13/2104 2 14

I need to pick that value of the Third column whose second column's value is the highest one.

In this example it should be 23 because 3 is the highest one.

Regards,

Saurabh

Re: How to sort and pick values.

anbu1984 — Thu, 25 Dec 2014 16:52:31 GMT

LOAD first,FirstSortedValue(second,-second) As second,FirstSortedValue(Third,-second) As Third Group By first;

Load * Inline [

first,second,Third

01/12/2014,1,12

01/12/2014,3,23

01/13/2104,2,14 ];