Pentaho 3.2 Data Integration Beginner's Guide

Time for action – using a Database lookup step to create a list of products to buy

Suppose you have an online system for your customers to order products. On a daily basis, the system creates a file with the orders information. Now you will check if you have stock for the ordered products and make a list of the products you'll have to buy.

1. Create a new transformation.
2. From the Input category of steps, drag a Get data from XML step to the canvas.
3. Use it to read the orders.xml file. In the Content tab, fill the Loop XPath option with the /orders/order string. In the Fields tab get the fields.
4. Do a preview. You will see the following:
   

   Note

   To keep this ...