Classifying the output data with aggregate element - 7.2

tXMLMap

EnrichVersion
7.2
EnrichProdName
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
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

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.