Skip to Content
0
Former Member
Feb 15, 2009 at 12:08 PM

Name Value pairs

25 Views

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