Skip to Content
avatar image
Former Member

Adding Rows To An XML Doc In An MII Trans

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 04:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 01:58 PM

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

    Regards,
    Christian


    Example.jpg (135.6 kB)
    Add comment
    10|10000 characters needed characters exceeded