Page 1 of 1
count distinct
Posted: Wed Mar 09, 2005 3:50 am
by jasper
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.
Posted: Wed Mar 09, 2005 4:51 am
by Amos.Rosmarin
Hi,
You can sort the data and generate change key column them count this field (it has 1,0 values).
HTH
Amos
Posted: Wed Mar 09, 2005 6:45 am
by roy
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,
Posted: Wed Mar 09, 2005 7:10 am
by Amos.Rosmarin
It's a property of the PX sort stage