Reading text files

PDI offers several steps to read text files. In the tutorial, we used the most generic one, the Text file input step.  The following table summarizes the options:

Step

Purpose

Characteristics

Text file input

This step is used to read a variety of text-files types, including CSV files and fixed-width flat files.

This is the most generic step for reading filesoffering a great flexibility for configuring the lecture. As explained in the previous sections, with this step, it is possible to read several files at the same time, as soon as they share the same format.

CSV file input

This step is used to read data from a file delimited by a comma (default) or but any other separator.

Compared to Text file ...

Get Learning Pentaho Data Integration 8 CE - Third Edition 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.