Thursday, May 13, 2010

How to get Distinct Count in Pentaho

0 comments
In order to get Distinct Count in the Kettel spoon
Go to the design mode drill down the Transformation folder and Drag & drop the  Unique Rows Step
image
this step remove the double and repeated Rows and give only unique occurrences but this works only on sorted input so you need to set a Sorted Rows Step available under the Transformation Folder jus drag & drop it  and make the hope between the two steps
image
If the input is not sorted, then only double consecutive rows are handled correctly.

0 comments: