Used to add a column to the data collected from the external XML sources. This is particularly useful if you want to set a default value for a column if the initial column is null, like a currency field.
Note: This procedure will occur before the Mapping XSL is applied.
Go to http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression(VS.71).aspx for more information.
Example:
<AddColumn>
<Column>
<ColumnName>DisplayData</ColumnName>
<ColumnType>System.String</ColumnType>
<Expression><![CDATA['<table cellspacing=0 cellpadding=0 border-0 width=250><tr><td align=left><a href="' + ObjSiteURL + '/' + DisplayPageURL + '?ID=' + ListID + '"><b>' + Title + '</b></a><br/>' + Description + '</td></tr></table>']]></Expression>
</Column>
</AddColumn>
The name of the column you want to add.
The type of column you want to add. Please see Convert XML" – "ColumnType" – "Options" for available options.
The expression used to store data within the column.