Calculated Field
The Calculated Field Transformation enables a user to create new column values by applying expressions, the result of which can be a newly defined column or it can replace the value in an existing one.
For example, the Agent could convert a temperature attribute on the incoming payload from Celsius to Fahrenheit - and either replace the temperature value or add a new attribute to the outgoing payload.
Statements can be written using a subset of the C# syntax. Refer to the example section for sample expressions and supported operations.
Details for an example and its configuration can be found in the How to Use section.
Pre-requisites
None at this time
Limitations
Not every C# syntax is supported. Here are some examples of NOT supported features:
Multiline expressions
for/foreach/while/do operators
Array/list/dictionary initialization
Explicit generic invocation (like
method<type>(arg)
)Lambda/delegate declaration (delegate and lamda are only supported as variables or parameters or as a return type of the expression)
Array/list/dictionary element assignment (set indexer operator)
Other operations on
dynamic
objects (only property, method invocation, and index now are supported)
Download
Please contact XMPro if you're looking for an older version of this Agent.
Last updated