How Do I Unify Data Elements? (Magic xpi 3.x)
To unify multi-occurrence data elements into a single data element, use the Compound Level Computation mechanism. This updates a variable, while iterating the Source compound, to create the unified Destination data.
A temporary variable (F.Var1) should be used to accumulate Source data.
Sample Schema:
To unify data elements:
-
Create a Data Mapper step.
-
Define the Source as an XML type, and the Destination as a variable. Choose the C.UserString as the dummy variable in order to allow the iteration.
-
Map a repeatable simple element Source compound to the Instance Destination, as shown below. Use the Destination’s Compound Level Computation interface under the Node Properties dialog box’s Advanced tab to update an Alpha variable (F.Var1) with the value of the simple element Source data. For example:
F.var1 & ' ' & Source/S3/Root/lines/Line
