Max Script function not working

[ramyasaiqv]

Hi All,
I am running into some issue with identifying the max record from the attached data set. Not sure if it's related to the null value. Please help resolve.
Issue: I am trying to get the max item no from the attached data set using below script. I am not running into any issues but not getting any data as out put.

Sample:

Load
max([Item NO]) as max_no,
Desc
from ..... Sample.xls
Group by Desc;

Thank you,
Ramya

[Digvijay_Singh · Accepted solution]

It worked for me, I attached this xlsx and used this script, I see ma Item no for a Description value, I have June 2020 Sense version.

LOAD
max([Item NO]) as max_no,
"Desc"
FROM [lib://AttachedFiles/Sample.xlsx]
(ooxml, embedded labels, table is Sheet1)
Group by Desc;

[ramyasaiqv]

Thank you Digvijay, it's weird some reason it didn't work for me in QS April 2019.  I tried in a different environment June 2020 and it's working.