Defining the schema - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

About this task

In this step, the schema parameters are set.

File - Step 4 of 5 dialog box.
The schema definition window is composed of four views:
  • Source Schema displays a tree view of the XML file.
  • Target Schema displays extraction and iteration information.
  • Preview displays a preview of the target schema, together with the input data of the selected columns displayed in the defined order.
    Note: The preview functionality is not available if you loaded an XSD file.
  • File Viewer displays a preview of the raw data.

First define an Xpath loop and the maximum number of times the loop can run. To do so:

Procedure

  1. Populate the XPath loop expression field with the absolute XPath expression for the node to be iterated upon. There are two ways to do this, either:
    • enter the absolute XPath expression for the node to be iterated upon (Enter the full expression or press Ctrl+Space to use the autocompletion list),

    • drop a node from the tree view under Source schema onto the Absolute XPath expression field.

      An orange arrow links the node to the corresponding expression.
      Source schema linked to Target schema with an orange link.
    Note: The Xpath loop expression field is mandatory.
  2. In the Loop limit field, specify the maximum number of times the selected node can be iterated, or -1 if you want to run it against all of the rows.
  3. Define the fields to be extracted dragging the node(s) of interest from the Source Schema tree into the Relative or absolute XPath expression fields.
    Note: You can select several nodes to drop on the table by pressing Ctrl or Shift and clicking the nodes of interest. The arrow linking an individual node selected on the Source Schema to the Fields to extract table are blue in color. The other ones are gray.
    Source schema linked to Target schema with orange and blue links.
  4. If needed, you can add as many columns to be extracted as necessary, delete columns or change the column order using the toolbar:
    • Add or delete a column using the add and remove buttons.

    • Change the order of the columns using the upward and downward buttons.

  5. In the Column name fields, enter labels for the columns to be displayed in the schema Preview area.
  6. Click Refresh Preview to display a preview of the target schema. The fields are consequently displayed in the schema according to the defined order.
    Note: The preview functionality is not available if you loaded an XSD file.
    Preview tab.
  7. Click Next to check and edit the end schema.