How can i use a Count Distinct in an Aggregator Stage??

avidal18 · Post by **avidal18** » Thu Jun 08, 2006 5:47 pm

I have a problem i'm tring to use a count distinct in an aggregator stage but i don't know how, because it is not a option in this stage, is there any other way to do this?? thnx

kris007 · Post by **kris007** » Thu Jun 08, 2006 6:16 pm

From what I understand from your question, you need to GROUP BY on your key column and then COUNT the records. If, this is not what you are looking for, as per me, you need to post more details. Also, what is your source stage, is it a table or flat file.

HTH
Kris

kumar_s · Post by **kumar_s** » Thu Jun 08, 2006 10:35 pm

You can acheive this by inserting any dummy field with a value 1. And sum it up in the Aggregator for each group to get the distince count for each group.