Hi I have script as follows:
t1:
LOAD * INLINE [
Branch Name, Result, Month, Year ,sort
BRADLEE, Pass, Jun-2015, 2015, 3
BUCKINGHAM, Pass, May-2015, 2015, 2
BUCKINGHAM, Fail, Jun-2015, 2015, 3
DUKE STREET, Fail, Apr-2015, 2015, 1
DUKE STREET, Pass, Jul-2015, 2015,4
LANDMARK, Pass, May-2015, 2015, 2
RIVERSIDE PARK, Fail, Apr-2015, 2015, 1
RIVERSIDE PARK, Pass, Jun-2015, 2015, 3
SEVEN CORNERS, Pass, Jul-2015, 2015, 4
SOUTH ARLINGTON, Pass, Jun-2015, 2015, 3
SOUTH ARLINGTON, Fail, Jul-2015, 2015, 4
];
i need to display branch,Result corresponding to max(sort) in each branch.
help pls...
