LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: bsmith

Is there a count distinct operator or script verb?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: bsmith

This is actually quite easy and can be done inside of an Agg node. For example, using the worldseries.csv file, if you wanted to do a count distinct on winner & winnerleague you would configure the node like this:

Specify what fields are to be evaluated as distinct in the GroupBy section (e.g. winner, winnerleague)
In the Script, add this:
[code:1]winnerCount = count()

emit winnerCount, winner, winnerleague where lastInGroup[/code:1]<br><br>Post edited by: bsmith, at: 2007/05/29 03:33