Column Action Block - SourceColumn

[Former Member]

Hi All,

I am building a xMII Document inside my transaction and the column names are dynamic.So i am using Column and Data Item action Blocks to build the document. I need to build the document where the SourceColumn and Name attributes of the Column Tag are different. I didn't find any option in Column action block to specify a different name for SourceColumn and Name Attributes. And the value of the Name attribute of the Column Tag will come under the Row as actual Data

Thanks,

Gowtham K.

[Former Member · Accepted solution]

Could you please illustrate what you are trying to accomplish using some sample data?

[agentry_src · Accepted solution]

Gowtham,

Can you also specify which version of MII you are using?

Thanks,

Mike

[Former Member · Accepted solution]

We are on MII 12.0.8(Build 19).

When we use the Tag Query with Statistics mode, it puts the tagname in source column and <Aggregate Function>_Tagname in Name attribute. MII UDS 4.0 doesn't support Event Weighted Total. So we are writing code inside MII to do that. And the results i have to pass to another transaction which will do further processing on these results. And that transaction is already built considering that the results will come from TagQuery where we have different values for SourceColumn and Name attributes.

[Former Member · Accepted solution]

Here is the Sample XML.

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

<Rowsets DateCreated="2010-02-23T07:16:15" EndDate="2010-02-23T01:00:00" StartDate="2010-02-23T00:00:00" Version="12.0.8 Build(19)"><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="OXIDIZR NATURAL GAS FLOW" MaxRange="0" MinRange="0" Name="Avg_MH.44F100.PV" SQLDataType="8" SourceColumn="MH.44F100.PV"/><Column Description="OXIDIZR NATURAL GAS FLOW" MaxRange="0" MinRange="0" Name="Avg_MH.44F100.PV_Quality" SQLDataType="12" SourceColumn="Avg_MH.44F100.PV"/><Column Description="OXIDIZR NATURAL GAS FLOW" MaxRange="0" MinRange="0" Name="Avg_MH.44F100.PV_Quality_Numeric" SQLDataType="4" SourceColumn="Avg_MH.44F100.PV"/></Columns><Row><DateTime>2010-02-23T00:00:00</DateTime><Avg_MH.44F100.PV>42.453499739965</Avg_MH.44F100.PV><Avg_MH.44F100.PV_Quality>HDA[Interpolated data value] DA[Good, Non-specific, Not Limited]</Avg_MH.44F100.PV_Quality><Avg_MH.44F100.PV_Quality_Numeric>131264</Avg_MH.44F100.PV_Quality_Numeric></Row></Rowset><?rowsets>

[jamie_cawley · Accepted solution]

You should be able to use an assignment to change the values.

Document_0.Output{/Rowsets/Rowset/Columns/Column[@Name = 'column name']/@SourceColumn}