Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ];
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 ];