CODEWITHSUNDEEP
pentahoetlkettledata-integration
Vicky
Vicky

Reputation: 349

pentaho kettle : get row count from stream

I would like to get the total record count from the get rows from result output and then pass it to parent job.

Any suggestions ?

enter image description here

Upvotes: 2

Views: 25537

Answers (2)

Otto
Otto

Reputation: 3294

this will be easily achieved adding a Get Value From Sequence step

if you name, for instance, a new var (see name of value on screenshot) called "counter" now you will have a row counter on this varsee this screenshot

at the last row you get this counter value and you get all the rows processed in the trans.

Upvotes: 1

Rishu S
Rishu S

Reputation: 3968

Try using "Group BY" or "Memory Group By" step to get the total count of the rows. select the type as : Number of rows in the step and it will return you the total count.

You can read the wiki also : http://wiki.pentaho.com/display/EAI/Group+By

Hope this helps :)

Upvotes: 3

Related Questions