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 – assigning tasks by filtering priorities with the Switch/Case step

Let's use a Switch/Case step to replace the nested Filter rows steps shown in the previous image.

  1. Create a transformation like the following:
    Time for action – assigning tasks by filtering priorities with the Switch/Case step
  2. You will find the Switch/Case step in the Flow category of steps.

    Tip

    To save time, you can take as starting point the last transformation you created. Configure the new Microsoft Excel Output steps just as you configured the others but changing the names of the output files.

  3. Create a hop, leaving the Switch/Case step towards the first of the Microsoft Excel Output steps. When prompted for the kind of hop to create, select Create ...

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