The Streaming Compute node uses an expression to create new computed fields or change the values of existing fields. Once new fields are added or the values of existing fields are changed, the Streaming Compute node's sheet will display all fields from its input node with the changes you have made.
This node performs a similar function to the Compute node, but the Streaming Compute node only produces and accepts streaming data.
Creating a new computed field
Using the Streaming Compute node to create a new computed field is effectively the same as adding a computed field in any other node's sheet.
- In the Computation Fields property, click Add.
- Give the field a unique Output Field Name that does not match the name of any other existing fields in the analysis.
- Select a data type for the field in the Output Field Type property.
- Create an expression that is used to populate the field's values.
Changing the values of an existing field
To change the values of fields that already exist in an input to the Streaming Compute node:
- In the Computation Fields property, click Add.
- Select an Output Field Name from the list of existing fields.
- Create an expression that is used to populate the field's values.
Properties
Display Name
Specify the name of the node that is displayed on the Analysis Designer canvas.
The default value is Streaming Compute.
Computation Fields
Click Add to create a new computed field or to change the values of an existing field.
View SQL
Click View SQL to see the SQL produced by the node.
You may want to modify the SQL for use with the Streaming SQL node, which allows you to customize your data transformations further.