Sum with distinct ID

[apthansh]

Looking for equivalent of below script in load script.Is it possible.

sum(aggr(sum(DISTINCT [Seats]), [key]))

Than you.

[its_anandrjs]

This is

Load DISTINCT

[key],

Sum([Seats])

From Source

Group By [key];

[its_anandrjs]

You can give name to sum field as well

Load DISTINCT

[key],

Sum([Seats]) as SeatsSum

From Source

Group By [key];

[dinuwanbr]

Try This

Load

Key,

count(distinct [Seats]) as SeatsSum

from [Source]

group by Key;

Rgds,

Tharindu