None

[#1]

None

[Nicole-Smith]

In the script, you can do:

INNER JOIN (YourTable)

LOAD Name,

max(B) as B

RESIDENT YourTable

GROUP BY Name;

[israrkhan]

fins the attached...

[#4]

Is it possible to do for third column instead of max(date(B))

I want to show corresponding Date according to the maximum of Date (A) so for example

id, a , b

a, 1/1/2012, 2/1/2013

a, 5/1/2012, 1/1/2010

then a should be

a, 5/1/2012, 1/1/2010

Currently it's just maximum ?

Thanks btw

[Gysbert_Wassenaar · Accepted solution]

Use firstsortedvalue(b,-a) to get the value of b for the maximum value of a

[#6]

It doesn't work !

If I don't select particular name, it gives me the correct A value out of all name, but when I do select a name, it fails !