Pentaho Kettle Script Option

Question

I am trying to use the Pentaho Kettle software for several conversions on my huge resources. I want to perform an operation that displays the contents of alternative rows in two different tables, and then I want to join the two tables later for further conversion.

The script parameter in the tool helps me with executing SQL scripts for one row or several rows. Can someone help me in choosing a row for this purpose.

Answer 1

It’s not very clear what you are trying to achieve, but the individual elements are pretty straightforward when you break them down into your discrete steps.

I would use the following steps:

• Table entry - allows you to make a query to connect the database to the SQL statement.
• Filter strings - allows you to split a data string into two separate paths based on the selected criteria in the data string.

You can combine two or more separate paths by connecting them to any type of step; that is, the step will process each row of data from any number of input paths separately and send it along the output path. In affect, all steps perform union operations.

One important principle to consider when using the Pentaho Kettle is never to assume that operations are performed sequentially (i.e., processed 1st, 2nd, 3rd, etc.). Operations occur in parallel along a data line; therefore, the first line can be sent along the path after the second line.

Hope this helps ...