Chapter 2. Reading and Writing Files
In this chapter we will cover:
- Reading a simple file
- Reading several files at the same time
- Reading semi-structured files
- Reading files having one field per row
- Reading files having some fields occupying two or more rows
- Writing a simple file
- Writing a semi-structured file
- Providing the name of a file (for reading or writing) dynamically
- Using the name of a file (or part of it) as a field
- Reading an Excel file
- Getting the value of specific cells in an Excel file
- Writing an Excel file with several sheets
- Writing an Excel file with a dynamic number of sheets
- Reading data from an AWS S3 Instance
Introduction
Files are the most primitive, but also the most used format to store and interchange data. PDI has the ability to read ...
Get Pentaho Data Integration Cookbook Second 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.
