Copy and Distribute row in Pentaho DI (Spoon)

Hi All,

When we connect a hop to a step, it shows below dialog box.


​

So what it means, today I'm going to explain this using a simple example transformation.

We have below sample data in data grid.

Now what happens if we connect data grid step with dummy (see below) using copy row.

It supply all rows to both dummy steps (see step metrics in bottom area)

​

​Let's figure out what distribute row does, in the same scenario.

​In above screenshot we can see dummy steps are getting just 5-5 rows, So if we use distribute rows option, the rows gets distributes to all connected steps.

Following are data sample of both dummy steps using distribute row.

Dummy1

Dummy 2

​

I hope this post will help you to understand the copy and distribute row option in Spoon.