pentaho kettle : get row count from stream

pentaho etl kettle data-integration
Vicky picture Vicky · Aug 5, 2015 · Viewed 17.1k times · Source

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

Answer

Rishu picture Rishu · Aug 5, 2015

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 :)

Related questions

Not able to run spoon.bat or any other batch file in Pentaho Data Integration (Kettle)

Tried pdi-ce-4.1.0-stable and pdi-ce-4.2.0-stable My Machine - Windows 7 64 bit When I run Spoon.bat cmd line window appears and disappears and then nothing happens. When I tried to run it from command line, I get DEBUG: Using JAVA_…

Read More
Using Pentaho Kettle, how do I load multiple tables from a single table while keeping referential integrity?

Need to load data from a single file with a 100,000+ records into multiple tables on MySQL maintaining the relationships defined in the file/tables; meaning the relationships already match. The solution should work on the latest version of MySQL, and …

Read More
How to get last 7 days data from current datetime to last 7 days in sql server

Hi I am loading table A data from sql server to mysql using pentaho when loading data i need to get only last 7 days data from sql server A table to mysql In sql server createddate column data type is …

Read More