topic Re: Max Script function not working in App Development

Max Script function not working

ramyasaiqv — Wed, 28 Apr 2021 00:14:56 GMT

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

Re: Max Script function not working

Digvijay_Singh — Wed, 28 Apr 2021 02:52:00 GMT

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;

Re: Max Script function not working

ramyasaiqv — Wed, 28 Apr 2021 12:13:53 GMT

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.