topic Re: error in load data in App Development

error in load data

somthingmendi123 — Mon, 15 May 2023 15:29:55 GMT

What does this error mean?

The following error occurred:

Aggregation expressions required by GROUP BY clause.

The error occurred here:

Load ItemID, CurrentStock, CurrentStockValue, CurrentStock / CurrentStockValue as ItemCost Resident Stock Group By ItemID

Re: error in load data

deepanshuSh — Mon, 15 May 2023 15:36:30 GMT

Hi,

It seems like you are not following the the correct syntax for using the group by function. You have to use an aggregation function like max, sum, count....etc. for using the group by function.

if you are just using a normal division or addition, group by clause is not needed.

Re: error in load data

Vegar — Mon, 15 May 2023 15:48:31 GMT

Why are you using group by. It is not necessary unless you want to do aggregations in your script.

Try

Load ItemID, CurrentStock, CurrentStockValue, CurrentStock / CurrentStockValue as ItemCost

Resident Stock ;

OR (if you want to aggregate)

Load ItemID, sum( CurrentStock), sum

(CurrentStockValue) , sum(CurrentStock) /sum( CurrentStockValue) as ItemCost

Resident Stock Group By ItemID;