appending rows into an xml file.

[Former Member]

Hi all,

Take a look at the xml file below:

<?xml version="1.0" encoding="UTF-8" ?>

- <Rowsets DateCreated="2007-11-26T11:56:17" EndDate="2007-11-26T11:51:33" StartDate="2007-11-26T11:51:33" Version="11.5.1">

- <Rowset>

- <Columns>

<Column Description="" MaxRange="1" MinRange="0" Name="name" SQLDataType="1" SourceColumn="name" />

<Column Description="" MaxRange="1" MinRange="0" Name="role" SQLDataType="1" SourceColumn="role" />

</Columns>

- <Row>

<name />

<role />

</Row>

<b></Rowset></b>

- <Row>

<name />

<role />

</Row>

</Rowsets>

In the above xml file, the problem is that the 2nd row is getting appended after the "</rowset>" tag.

How to append it before the "</rowset>" tag??

Please help.

[Former Member · Accepted solution]

hi,

I took the xml in transaction xml variable(input) and the next seperate row in the local xml varialbe(add)

In link editor

Transaction.input{/Rowsets/Rowset} ---> Local.add{/Row}

Use the option append xml...

Regards,

Kishore

[jcgood25]

If you use the Row action block and configure it to your xml variable (assuming it has a default value visible in the link editor) as the document, the action block should show you the 'name' and 'role' data items for you to link to in your logic. Note: this should only work when the xml structure is in the Illuminator document format.

Regards,

Jeremy