cancel
Showing results for 
Search instead for 
Did you mean: 

Minitab to XML conversion

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi

You may use the "Column" action (under xMII XML Output in BLS) and "Row" action to set the column names and map the values in the rows respectively in the XML file. Of course you have to use 'Repeater' action to loop the input table contents to be shown in the XML output.

Regards

Som

Former Member
0 Kudos

any help doc on this?

-senthil