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