Pentaho Data Integration Beginner's Guide

Time for action – reading all your files at a time using a single text file input step and regular expressions

You can do the same thing that you did previously by using a different notation. Follow these instructions:

1. Open the transformation that reads several files and double-click on the Input step.
2. Delete the lines with the names of the files.
3. In the first row of the grid, under the File/Directory column, type the full path of the input folder, for example C:\pdi_files\input.
4. Under the Wildcard (RegExp) column type (usa|europe)_[0-9]{6}\.txt.
5. Click on the Show filename(s)... button. You will see the list of files that match the expression:
   
6. Close the ...