on 08-30-2007 6:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any help doc on this?
-senthil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.