topic Re: Stupid script error in App Development

Stupid script error

Broly — Sat, 16 Nov 2024 01:03:24 GMT

Hi guys,

It is late and I am going to sleep now, but I get this error:

The following error occurred:

Invalid expression

test:
load
SHIPMENT_ID,
Min(MinLoadTime) as MinLoadTimeUG
Resident
bi_shipments
Group by DepotID,H_ROUTE_NAME,ORDER_EXECUTION_DATE
Order by DepotID,H_ROUTE_NAME,LASTACTION_TIME_DATA_SOURCE asc
;

The following error occurred:

Invalid expression

Can someone tell me what is wrong?

Thank you, and good night

Re: Stupid script error

MayilVahanan — Wed, 25 Nov 2020 02:53:57 GMT

Hi @Broly

You need to include "SHIPMENT_ID" in the "group by" to avoid the issue.

Can you explain, why you mentioned many field in the group by?

Re: Stupid script error

PrashantSangle — Wed, 25 Nov 2020 03:57:30 GMT

you need to include only non aggregated fields which are using resident table. try below code

Test:
load
SHIPMENT_ID,
Min(MinLoadTime) as MinLoadTimeUG
Resident
bi_shipments
Group by SHIPMENT_ID
Order by SHIPMENT_ID asc
;