O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

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

Time for action – deleting data about discontinued items

Suppose a manufacturer informs you about the categories of products that will no longer be available. You don't want to have those products in your database that you will not sell. So you use PDI to delete them.

  1. Open the LUX_discontinued.txt file available in the code bundle.
  2. Create a new transformation.
  3. With a Text file input step, read the file. As Number of header lines, type 4. Add a single field of type String and name it category.
  4. Preview the file. You will see the following:
    Time for action – deleting data about discontinued items
  5. After the Text file input step, add an Add constants step to add a String constant named man_code with value LUX

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