Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
It is late and I am going to sleep now, but I get this error:
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?
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?
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
;