Procedure
-
Double-click the tXMLMap component to open its Map Editor.
Note that the input area is already filled with the defined input tables and the top table is the main input table. -
In the imported XML tree, right-click the States node and from the contextual menu select As loop element to set it as the loop element.
-
In the row1 main input table, click the
idState node and drop it to the Exp.key column in the row of the idState
node in the row2 lookup input table. This
creates a join between the two input tables on the idState
data, among which the idState node from the main flow
provides the lookup key.
-
In the row2 lookup input table, click the
LabelState node and drop it on the
customer node in the Customer output table. A dialog box pops up.
-
In the pop-up dialog box, select Create as sub-element
of target node and click OK. A
new LabelState sub-element is added to the
output XML tree and mapped with the LabelState node in the
lookup input table.
