Skip to Content
0
Former Member
Nov 29, 2006 at 08:05 PM

useOneAsMany and splitByValue

36 Views

Hello all.

I am attempting to take an XML structure similar to this:

<u><b>source</b></u>

-<recordset>

-


<header>

-


<element1>12,34,56,78</element1>

-


</header>

-</recordset>

And using a target data type similar to this:

-<recordset>

-


<header>

-


<subtree1>

-


<element1>

-


</subtree1>

-


</header>

-</recordset>

<u><b>Create a result of:</b></u>

-<recordset>

-


<header>

-


<subtree1>

-


<element1>12</element1>

-


</subtree1>

-


<subtree1>

-


<element1>34</element1>

-


</subtree1>

-


<subtree1>

-


<element1>56</element1>

-


</subtree1>

-


<subtree1>

-


<element1>78</element1>

-


</subtree1>

-


</header>

-</recordset>

I have done several tests, and I've gotten the <i>splitByValue</i> function to work when there are multiple instances of <element1> in the source file. However, I need to basically do a splitByValue when there is only one instance of <element1>, but with the multple variables in that field.

I'm thinking if I can find a way to combine <i>useOneAsMany</i>, <i>splitByValue</i>, and something else, I can accomplish this goal. Does anyone have any hints? Or know if I'm even on the right path?