This example demonstrates how to use this Transformation to substitute null pump data with the minimum value from the previous 3 events.
Refer to configuration to understand all configuration options of this Agent.

Step 1: Add the Agent

Drag the Missing Values Detector Transformation onto the canvas and link the input endpoint to the pump data. Save the Data Stream.

Step 2: Configure General

Select the Agent and click Configure. In this case, keep the default Collection.

Step 3: Configure Settings

Set the attributes to substitute, what to substitute them with, and the window size.
In this case, set the attributes to substitute to PumpName and Temperature, substitute with to Maximum, and window size to 3.
This will substitute the pump name with that of the previous value and the temperature with the maximum value of the 3 previous records. Both empty and null values will be replaced, and the first event will be ignored if it contains empty or null values.

Step 4: Results

Apply the changes, save the Data Stream and publish it.
Let's look at the Live Data View. Observe that null or empty values for Pump Name and Temperature are substituted with the previous value and maximum, respectively.


Security Key
Data Stream
MVS Example.xuc
Sample File
Pump Data.csv
See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.