Adding Rows To An XML Doc In An MII Trans

[former_member1170711]

I have a case where I want to add rows to an existing XML document in an MII transaction.  Picture an XML doc that already has 100 rows in it and I want to add another row to it so that it now has 101 rows.  The document is not in MII XML format (rowsets/rowset/row) but it is similar.

As a simplified example, let's say I started with this doc:

Document A:

<rowset>

    <row><name>fred</name></row>

    <row><name>wilma</name></row>

    <row><name>barney</name></row>

    <row><name>betty</name></row>

<rowset>

And I had another doc that just had this:

Document B:

    <row><name>dino</name></row>

How would I add document B to document A so that I end up with this:

<rowset>

    <row><name>fred</name></row>

    <row><name>wilma</name></row>

    <row><name>barney</name></row>

    <row><name>betty</name></row>

    <row><name>dino</name></row>

<rowset>

Thanks in advance for your time!

-Mike

[swaroop_anasane · Accepted solution]

Hi Mike,

Instead of assign xml, you can use append xml in expression editor. This would add row to existing xml.

Also, doc A doesn't look like it's in mii Rowsets/Rowset/Row format. MII's format doesn't have column name under row element.

Hope it helps.

Best Regards,

Swaroop

[former_member185280]

Here is screenshot of an example that does what you are asking.

Regards,
Christian