scripting

[#1]

what is wrong with below script?

Load

country,

sum(sales)

from sales.qvd;

[tresesco]

Missing group by. Try like:

Load

country,

sum(sales)

from sales.qvd group by country;

[its_anandrjs]

Group By is missing

Load

country,

sum(sales)

from sales.qvd

Group By

country;

Regards

Anand

[MarcoWedel]

When using aggregation functions (count, sum, min, max, avg, ...) in a load (or select), you have to include ALL fields without aggregation function in the group by clause.

hope this helps

regards

Marco