count distinct

jasper · Post by **jasper** » Wed Mar 09, 2005 3:50 am

in an aggregation job we need to calculate a count distinct.
How do we do this, it is not a standard option in the aggregator-stage.

Amos.Rosmarin · Post by **Amos.Rosmarin** » Wed Mar 09, 2005 4:51 am

Hi,

You can sort the data and generate change key column them count this field (it has 1,0 values).

HTH
Amos

roy · Post by **roy** » Wed Mar 09, 2005 6:45 am

Hi,
Start by performing a search here.
that would have poped this up:
viewtopic.php?t=91232

by the way Amos Im not sure I fully understand what you said.

IHTH,

Amos.Rosmarin · Post by **Amos.Rosmarin** » Wed Mar 09, 2005 7:10 am

It's a property of the PX sort stage