XML to XML XSLT Transform
Posted: Thu Aug 02, 2018 2:32 pm
XSLT help please
i want to combine the element in to one line.
original xml
<?xml version="1.0" encoding="UTF-8"?>
<Log>
<SQLStatementValue>
<Row>
<Column Name="SOID" DataType="INTEGER">123</Column>
<Column Name="REFERENCE" DataType="BINARY">Test1</Column>
<Column Name="CUSORDERNO" DataType="BINARY">Order1</Column>
</Row>
<Row>
<Column Name="SOID" DataType="INTEGER">456</Column>
<Column Name="REFERENCE" DataType="BINARY">Test2</Column>
<Column Name="CUSORDERNO" DataType="BINARY">Order2</Column>
</Row>
</SQLStatementValue>
</Log>
the result i want, hopefully this is possible.
<Log>
<SQLStatementValue>
<Row>
<Column Name="SOID" DataType="INTEGER">123 Test1 Order1</Column>
</Row>
<Row>
<Column Name="SOID" DataType="INTEGER">456 Test2 Order2</Column>
</Row>
</SQLStatementValue>
</Log>
i want to combine the element in to one line.
original xml
<?xml version="1.0" encoding="UTF-8"?>
<Log>
<SQLStatementValue>
<Row>
<Column Name="SOID" DataType="INTEGER">123</Column>
<Column Name="REFERENCE" DataType="BINARY">Test1</Column>
<Column Name="CUSORDERNO" DataType="BINARY">Order1</Column>
</Row>
<Row>
<Column Name="SOID" DataType="INTEGER">456</Column>
<Column Name="REFERENCE" DataType="BINARY">Test2</Column>
<Column Name="CUSORDERNO" DataType="BINARY">Order2</Column>
</Row>
</SQLStatementValue>
</Log>
the result i want, hopefully this is possible.
<Log>
<SQLStatementValue>
<Row>
<Column Name="SOID" DataType="INTEGER">123 Test1 Order1</Column>
</Row>
<Row>
<Column Name="SOID" DataType="INTEGER">456 Test2 Order2</Column>
</Row>
</SQLStatementValue>
</Log>