Hi All,
I am trying to achieve the following using the graphical mapping tool.
Source:
rows..................0-unbounded
.....indicator1......1-1
.....indicator2......1-1
.....indicator3......1-1
Target:
Attributes...........0-unbounded
.....constant............1-1
.....field...................1-1
Sample Source xml:
<rows>
....<indicator1>Blue</indicator1>
....<indicator2>Large</indicator2>
....<indicator3>Hot</indicator3>
</rows>
In the target structure, I want to create name value pairs where constant1 is assigned constant 'Colour' and field1 is assigned indicator1.
My issue is that in the target structure, I also want to create new name value pairs for each of the values in the source. This is illustrated in the target document example below:
<Attributes>
......<constant>"Constant"</constant>
......<field>indicator1</field>
</Attributes>
<Attributes>
......<constant>"Constant"</constant>
......<field>indicator2</field>
</Attributes>
<Attributes>
......<constant>"Constant"</constant>
......<field>indicator3</field>
</Attributes>
An example would be (using the sample values above):
<Attributes>
......<constant>Color</constant>
......<field>Blue</field>
</Attributes>
<Attributes>
......<constant>Size</constant>
......<field>Large</field>
</Attributes>
<Attributes>
......<constant>Wash</constant>
......<field>Hot</field>
</Attributes>
Can this be achieved in the graphical mapping tool before I turn to xslt?
Please help!
Regards,
JS