Classifying the output data with aggregate element - 7.3

tXMLMap
Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
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
Data Governance > Third-party systems > Processing components (Integration) > tXMLMap
Data Quality and Preparation > Third-party systems > Processing components (Integration) > tXMLMap
Design and Development > Third-party systems > Processing components (Integration) > tXMLMap
Last publication date
2024-02-21

Procedure

  1. In your Studio, open the Job used in , and double-click the tXMLMap component to open its Map Editor.
  2. Right-click the customer element in the output table and select Remove group element from the contextual menu.
  3. On the top of the output table, click the wrench icon and set the value of the All in one property to false.
  4. Right-click the LabelState element and select As aggregate element from the contextual menu. The LabelState element tags the state information of each customer and the customer information will be classified according to the state information.

    To make the aggregate element available, ensure that the value of the All in one property is set to false. For further information about the All in one feature, see Talend Studio User Guide.

  5. Click OK to validate the changes and close the Map Editor.
  6. Press Ctrl+S to save the Job and then F6 to run the Job.

Results

As shown above, tXMLMap outputs two separate XML flows, each of which carries the information of one state and the customers from that state.