Pentaho: How to read SQL result row by row to execute one by one?

Question

i built a simple transform for select rows data from table in the database using Table Input.

i know that Table Input return all result one time. but what i need to do is to get result row by row and continue the process, then return back to the next row and so on.

so any ideas please ?

score 2 · Accepted Answer · answered Jul 23 '14 at 06:38

Answer from Pentaho Forums :

Build a job, and let the first transformation retrieve all the rows via Table Input. Use a "Copy rows to result" step to save the result. Create a second transformation configured for single row execution - see advanced transformation settings. Use "Get rows from result" to start single row processing.

in addition to :

Transformation Executor

Pentaho: How to read SQL result row by row to execute one by one?

1 Answers1