script reduce to max data only

[userid128223]

I have file like attached. i need to select reduce data during script to max date.

Result will be:

2017-05-29 10:25:32:238

Chemistry

3

C

afd

[neelamsaroha157]

Check this.

This will fetch you data for the max date.

[Digvijay_Singh]

Data:

Load

  Timestamp(Max(Date)) as Date,

  FirstSortedValue(Class,-Date) as Class,

  FirstSortedValue(Grade,-Date) as Grade,

  FirstSortedValue(Teacher,-Date)  as Teacher,

  FirstSortedValue(Notes,-Date) as Notes;

LOAD

  Timestamp(Timestamp#(Date,'YYYY-MM-DD hh:mm:ss:fff'),'YYYY-MM-DD hh:mm:ss:fff') as Date,

  Class,

  Grade,

  Teacher,

  Notes

FROM

firstsortedValuedata.xlsx

(ooxml, embedded labels, table is Sheet1);