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?