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.
- Create a new transformation.
- From the Input category of steps, drag a Get data from XML step to the canvas.
- Use it to read the
orders.xmlfile. In the Content tab, fill the Loop XPath option with the
/orders/orderstring. In the Fields tab get the fields.
- Do a preview. You will see the following:
To keep this exercise ...