In the XML tree view of the Customer output table,
right-click the customer (loop) node and select Delete from the contextual menu.
All of the elements under the customers root node are
removed, you can now reconstruct the XML tree view that can be used to group the
output data of interest.
Right-click the customers root node and select
Create Sub-Element from the
contextual menu. In the pop-up dialog box, enter the name of the new
sub-element. In this example, it is customer.
Click OK to validate the changes and close
the dialog box.
In the row2 lookup input table, select the LabelState node and drop it onto the customer node in the output table. In the pop-up dialog box, select
Create as sub-element of target node and
click OK to close the dialog box.
Right-click the customer node in the output table and
select Create Sub-Element from the
contextual menu. In the pop-up dialog box, enter the name of the new
sub-element. In this example, it is Name.
Click OK to validate the changes and close
the dialog box.
In the row1 main input table, select the id and
CustomerName nodes and drop them onto the
Name node in the output table. In the pop-up dialog box,
select Create as sub-element of target node
and click OK to close the dialog box.
In the output table, right-click the Name node and from
the contextual menu select As loop
element to set it as the loop element, then right-click the customer node and from the contextual menu select
As group element to group the output
data according to the LabelState element.
Click OK to validate the changes and
close the map editor.
Press Ctrl+S to save the Job and then
F6 to run the Job.
Results
The id element and the CustomerName element contained
in the loop are grouped according to the LabelState element. The group
element customer tags the start and the end of each group.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
All of the elements under the customers root node are removed, you can now reconstruct the XML tree view that can be used to group the output data of interest.
