cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Rows - How to construct

IntegrationCPI
Participant
0 Kudos

I have created a Dynamic column but having difficulty in populating the data into rows . attached the screen shot of the transaction .

I could populate the below XML using the ROW Action block  by mapping the link

Row_0.Fluid_Pressure

Repeater_1.Output{/Row/Fluid_Pressure}

Is there anyway i can make this dynamic like below  so that i can use this as  generic template

"ROW. #Dynamic Element Name#

Repeater_1.Output{/Row/#Dynamic Element Name#}

One alternate way is to simply bind the XSL template to  any data source XML in the transaction using the  Xacute query .Let me know is there anyway i can achieve this without using the XSL .

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

<Rowsets DateCreated="2013-02-20T15:33:47" EndDate="2013-02-18T16:52:20" StartDate="2013-02-18T16:52:20" Version="12.2.3 Build(182)">

    <Rowset>

        <Columns>

            <Column Description="Flow Rate" MaxRange="1" MinRange="0" Name="Flow_Rate" SQLDataType="1" SourceColumn="Flow_Rate"/>

            <Column Description="Pump Status" MaxRange="1" MinRange="0" Name="Pump_Status" SQLDataType="1" SourceColumn="Pump_Status"/>

            <Column Description="Fluid Pressure" MaxRange="1" MinRange="0" Name="Fluid_Pressure" SQLDataType="1" SourceColumn="Fluid_Pressure"/>

        </Columns>

        <Row>

            <Flow_Rate>30</Flow_Rate>

            <Pump_Status>On</Pump_Status>

            <Fluid_Pressure>27</Fluid_Pressure>

        </Row>

        <Row>

            <Flow_Rate>30</Flow_Rate>

            <Pump_Status>On</Pump_Status>

            <Fluid_Pressure>27</Fluid_Pressure>

        </Row>

        <Row>

            <Flow_Rate>40</Flow_Rate>

            <Pump_Status>On</Pump_Status>

            <Fluid_Pressure>80</Fluid_Pressure>

        </Row>

</Rowset>

</Rowsets>

Accepted Solutions (1)

Accepted Solutions (1)

agentry_src
Active Contributor
0 Kudos

Hi Kishore,

I created a sample trx a long time ago, but it is still valid for use.  This is a screenshot, but if you want the actual transaction contact me directly.

Create the Illum Doc without any colums.

Add a Rowset

Create the columns dynamically (externally provided names)

Add a Row

Add Data Items referenced with the same externally provided names that you used to create the columns.

Repeat.

Regards, Mike

Answers (0)