An example Data Stream can be found below that demonstrates how to use this Transformation to add two new fields: a conversion to Fahrenheit and a 'hot' indicator.
Calculated Field Example.xuc
Country, Location, Unit and Vibration in the examples below are attribute names.
Create a new string using data points from the stream
"Request from " + Country + ", " + Location + " for unit: " + Unit
Add a "+" sign to add string values together.
Create a hard-coded new string value
"Demonstration Unit #A2"
Using the short-hand If-statement the following reads “If the vibration is larger than 9000 then value is High otherwise it’s Medium”
Vibration > 9000 ? "High" : "Medium"
Current date and time
Add two days to the current date and time
This will return true or false. Please note that the Data Type needs to be set to Boolean.
Vibration > 9000
Any C# Math library function can be used to alter data as needed. Any method within the library can be used without issue.
Power of 3
Round to 4 decimal Places
Relational and type testing