How to use Aggregation at script level

[#1]

Can anybody tell how to use How to use Aggregation at script level

Thanks

[anbu1984]

Do you mean using Aggr() ?

[#3]

Yes Cheliyan,

In Designing we can write avg(aggr(sum(sales),Country)), like this.

similar way i should do the same in the script level

Thanks

[anbu1984]

You cannot use Aggr() in script. You can try like this

Initial:

Load * Inline [

Country,Sales,Year

India,1000,2013

India,2000,2014

China,1000,2013

China,200,2014 ];

Join(Initial)

Load Country,Sum(Sales)/Count(Country) As Avg Resident Initial Group by Country;

[MarcoWedel]

Hi,

there are multiple aggregation functions for the script, they all have in common that there must be a group by clause for all fields loaded but not aggregated:

hope this helps

regards

Marco