How can i use a Count Distinct in an Aggregator Stage??
Moderators: chulett, rschirm, roy
How can i use a Count Distinct in an Aggregator Stage??
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
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
HTH
Kris
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson