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

You could do the same thing you did above by using a different notation. Follow these instructions:

  1. Open the transformation and edit the configuration windows of the input step.
  2. Delete the lines with the names of the files.
  3. In the first row of the grid, type C:\pdi_files\input\ under the File/Directory column, and group[1-4]\.txt under the Wildcard (Reg.Exp.) column.
  4. Click the Show filename(s)... button. You'll see the list of files that match the expression.
    Time fordata, readingmultiple files, reading at once action – reading all your files at a time using a single Text file input step and regular expressions
  5. Close the tiny window and click Preview rows to confirm that the rows shown belong ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial