Skip to Content
0
Sep 14, 2010 at 01:16 PM

Unbounded to falt structure mapping

14 Views

Hello,

I think I have a very easy mapping problem but I do not find the solution.

I want to map

<field> maxoccurs = 4

to

<field1>

<field2>

<field3>

<field4>

so the first occurance of <field> should goto <field1> ....

Source

<field>value1</field>

<field>value2</field>

<field>value3</field>

target

<field1>value1</field1>

<field2>value2</field2>

<field3>value3</field3>

Does this work with built-in function or do I have to write a UDF....???

best regards

Werner