Transforming Files - Getting Started with Talend Open Studio for Data Integration - page 36

XPath is a query language for finding information in an XML
document. It uses path expressions to navigate to the required elements.
XPath is a big subject in its own right, and it is outside the scope of this
topic to go into detail on the subject. However, W3C Schools provides
an excellent tutorial on the subject at http://www.w3schools.com/
xpath/ , and readers may wish to take some time to read through this.
10. Click on the Refresh Preview button in the bottom left-hand corner of the
window, and the Studio will read the file and preview the extract of the data
in a tabular format. Click on Next to move to step 5.
11. Step 5 of the metadata setup allows us to confirm or alter the schema as
determined by the wizard and add this to the Repository window. The Studio
has determined data types, field length, and precision values. In this case, we
can make a couple of changes. Our skuid field is a unique key, so we can note
as such in the schema by checking the Key checkbox for the skuid row. As
skuid is a key, we would need it to be present for every record, so it cannot be
nullable. Uncheck the Nullable checkbox for the skuid row. Finally, for this
step, change the Name field to catalogue . Click on Finish :