Page 1 of 1
How can i use a Count Distinct in an Aggregator Stage??
Posted: Thu Jun 08, 2006 5:47 pm
by avidal18
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
Posted: Thu Jun 08, 2006 6:16 pm
by kris007
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
Posted: Thu Jun 08, 2006 10:35 pm
by kumar_s
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.