Aliasing column name and adding with xml in BLS

[Former Member]

Dear Experts,

I have some xml in a variable and a repeater which will give a column at a time with different no of rows. And i want to add the newly column to previous xml.And my repeater column name(Value) is same, so i want to repalce the column with repeater current item(Value1,Value2........).M getting the final xml structure is below.I am able to see the Valu1,Valu2 columns in the Rowset but not in the Row.In Row i am getting <Value></Value> only.m using using XSL_Trans block and RowsetCombiner.xsl.Plz provide me wht changes needs to done in my bls.

<?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2011-08-17T02:41:45" EndDate="2011-06-30T11:24:30" StartDate="2011-06-25T11:29:07" Version="12.1.8 Build(20)">

<Rowset>

<Columns>

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

<Column Description="ROP_100" MaxRange="6" MinRange="4" Name="ROP_100" SQLDataType="8" SourceColumn="ROP_100"/>

<Column Description="LCL" MaxRange="1.0" MinRange="0.0" Name="LCL" SQLDataType="7" SourceColumn="LCL"/>

<Column Description="SPC_Target" MaxRange="1.0" MinRange="0.0" Name="SPC_Target" SQLDataType="7" SourceColumn="SPC_Target"/>

<Column Description="UCL" MaxRange="1.0" MinRange="0.0" Name="UCL" SQLDataType="7" SourceColumn="UCL"/>

<Column Description="LSL" MaxRange="1.0" MinRange="0.0" Name="LSL" SQLDataType="7" SourceColumn="LSL"/>

<Column Description="USL" MaxRange="1.0" MinRange="0.0" Name="USL" SQLDataType="7" SourceColumn="USL"/>

<Column Description="CL" MaxRange="1.0" MinRange="0.0" Name="CL" SQLDataType="7" SourceColumn="CL"/>

<Column Description="Value1" MaxRange="1" MinRange="0" Name="Value1" SQLDataType="8" SourceColumn="Value"/>

<Column Description="Value2" MaxRange="1" MinRange="0" Name="Value2" SQLDataType="8" SourceColumn="Value"/>

</Columns>

<Row>

<DateTime>2011-06-25T11:29:07</DateTime>

<ROP_100>6</ROP_100>

<LCL>30</LCL>

<SPC_Target>20</SPC_Target>

<UCL>33</UCL>

<LSL>50</LSL>

<USL>30</USL>

<CL>24</CL>

<Value>15</Value>

</Row>

<Row>

<DateTime>2011-06-25T23:28:39</DateTime>

<ROP_100>4</ROP_100>

<LCL>30</LCL>

<SPC_Target>20</SPC_Target>

<UCL>33</UCL>

<LSL>50</LSL>

<USL>30</USL>

<CL>24</CL>

<Value>70.068785023881</Value>

</Row>

Thanks in Advance

Eswaraiah M

[Former Member]

Hi,

I didn't understand your requirement. But why are you using XSL Transformation.you can use Column aliasing and Calculated Column actions to change the name of the column and add extra column to the existing XML Document.

Please post your source xml and target xml. It will be easy to understand.

Thanks,

Gowtham K.

[Former Member]

Hi Gowtham,

Thanks for reply.My requirement is like, i have xml of 3 columns.Now i have a repeater which will return a column at a time.so based on repeater count i want change the column name and add it to previous xml

DateTime ROP_100 LCL SPC_Target UCL USL CL Value1 Value2

06/25/2011 11:29:07 6.00 30.00 20.00 33.00 30.00 24.00 NA NA

06/25/2011 23:28:39 4.00 30.00 20.00 33.00 30.00 24.00 NA NA

06/26/2011 11:28:11 5.47 30.00 20.00 33.00 30.00 24.00 NA NA

06/26/2011 23:27:43 4.00 30.00 20.00 33.00 30.00 24.00 NA NA

06/27/2011 11:27:16 4.00 30.00 20.00 33.00 30.00 24.00 NA NA

06/27/2011 23:26:48 6.00 30.00 20.00 33.00 30.00 24.00 NA NA

06/28/2011 11:26:20 4.00 30.00 20.00 33.00 30.00 24.00 NA NA

06/28/2011 23:25:53 4.47 30.00 20.00 33.00 30.00 24.00 NA NA

06/29/2011 11:25:25 4.11 30.00 20.00 33.00 30.00 24.00 NA NA

06/29/2011 23:24:57 4.00 30.00 20.00 33.00 30.00 24.00 NA NA

something similar to above format.my repeater out column name is "Value" based on repeater count a want to change it to Value1...Value2 and add them to previous xml.plz provide me logic

Thanks in advance

Eswaraiah M

Edited by: Eswaraiah M on Aug 19, 2011 9:48 AM