PDI has a step named Get XML Data used to read XML structures. This recipe shows how to read an XML file containing the information about museums using this step.
In this exercise, you will use a file named
museum.xml with the following structure:
<museums> <museum id_museum= '…'> <name>…</name> <city>…</city> <country>…</country> </museum> </museums>
Carry out the following steps:
museums.xmland click on the Add button.
/museums/museumin the Loop XPath textbox. This will be the current node.