Skip to Content
0
Former Member
Aug 30, 2007 at 05:55 AM

Minitab to XML conversion

31 Views

Hi,

i have table in Minitab as

S0190 S0192 S0195

47 44 47

where S0190,S0192,S0195 are column names. i tried to convert this into XML format in BLS. I loaded this mtw file in text loader and connected to Flat file parser as text loader string content to Flat file parser input. i got output for this as

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

- <Rowsets DateCreated="2007-08-29T19:33:11" EndDate="2007-08-29T19:33:11" StartDate="2007-08-29T19:33:11" Version="11.5.3">

- <Rowset>

- <Columns>

<Column Description="LineNumber" MaxRange="0" MinRange="0" Name="LineNumber" SQLDataType="5" SourceColumn="LineNumber" />

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

</Columns>

- <Row>

<LineNumber>1</LineNumber>

<Line>'S0190'</Line>

</Row>

- <Row>

<LineNumber>2</LineNumber>

<Line>'S0192'</Line>

</Row>

- <Row>

<LineNumber>3</LineNumber>

<Line>'S0195'</Line>

</Row>

- <Row>

<LineNumber>4</LineNumber>

<Line />

</Row>

- <Row>

<LineNumber>5</LineNumber>

<Line>4,700000000e+001</Line>

</Row>

- <Row>

<LineNumber>6</LineNumber>

<Line>4,400000000e+001</Line>

</Row>

- <Row>

<LineNumber>7</LineNumber>

<Line>4,700000000e+001</Line>

</Row>

- <Row>

<LineNumber>8</LineNumber>

<Line />

</Row>

</Rowset>

</Rowsets>

i tried many ways to convert this into xMII XML format, but didnt get XML format. how to convert this format into XML format? can i use repeater, for next? In this it take column names (S0190..) as rows. how to set as column in XML format?

thanks in advance

-senthil