O'Reilly logo

Pentaho Data Integration 4 Cookbook by María Carina Roldán, Adrián Sergio Pulvirenti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Reading and Writing Files

In this chapter, we will cover:

  • Reading a simple file
  • Reading several files at the same time
  • Reading unstructured files
  • Reading files having one field by row
  • Reading files having some fields occupying two or more rows
  • Writing a simple file
  • Writing an unstructured 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

Introduction

Files are the most primitive, but also the most used format to store and interchange data. PDI has the ability to read data from all kind of files and different ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required