Mapping Query

[Former Member]

Hi,

I am wondering if it is possible to as follows:

i.e. Move the unbounded element up one level as in the following example:

<evidence>

   <file>file1</file> 

   <file>file2</file>

   <file>file3</file>

</evidence>

to

<evidence>

   <file>file1</file>

</evidence>

<evidence>

   <file>file2</file>

</evidence>

<evidence>

   <file>file3</file>

</evidence>

The data is required in this format due to processing constraints within the system which receives the message. At the moment I am unable to get this to work. If I map as follows:

I get:

<evidence>

   <file>file1</file>

</evidence>

<evidence></evidence>

<evidence></evidence>

i.e. I get the correct number of 'evidence' nodes, but they are empty - guessing this is because I am mapping URL (0..1) to file (0..U), but I can't see what else to map. Anyone know how to get this to work as outlined above?

Cheers,

Paul Clements.

[sendhil_kumar · Accepted solution]

Hi Paul,

Yes, It is Possible. Try this.

First Map Evidence ->Evidence.

From your structure, I see that Url is mapped to File. So the target structure would be

Next

File -> SplitbyValue(EachValue) ->url

<evidence>

   <url>file1</url>

</evidence>

<evidence>

   <url>file2</url>

</evidence>

<evidence>

   <url>file3</url>

</evidence>

Hope this helps.

-

Sendhil

[Former Member · Accepted solution]

Sendhil,

Thanks for the correct answer. My mapping is now working as expected:

Cheers,

PaulC.