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.
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 ...