O'Reilly logo

Pentaho Data Integration 4 Cookbook by María Carina Roldán, Adrián Sergio Pulvirenti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Copying or moving a custom list of files

Sometimes, you don't have the names of files to move or copy beforehand. In these cases, you can take advantage of the Add filename to result prompt existing in several Kettle steps and job entries.

Let's see an example. Suppose that you receive Excel files daily with book orders from different branches and, you need to process these files creating a new Excel file with all the incoming orders. Then, finally, you want to move the source files to a destination folder.

Getting ready

In order to do this exercise, you need a directory named booksOrders with several Excel files. Each file should have two columns: one for the id_title and another for the Quantity. Also, it is necessary to have a destination folder ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required