Example

This example demonstrates how to use this Transformation to amend the pump data attributes as follows:

• Rename 'ReadingNo' to 'ReadingId'

• Rename 'PumpId' to 'AssetId' and move it to the first position

• Remove 'ToRemove'

• Reorder 'Timestamp' from the end to before the temperature and flow rate

Refer to configuration to understand all configuration options of this Agent.

Step 1: Add the Agent

Drag the Alter Attribute Agent onto the canvas, link the input endpoint to the pump data, and the output to the printer. Rename the Agent and save the Data Stream.

Step 2: Configure General

Select the Agent and click Configure. Keep the default Collection.

Step 3: Configure Alter Options

The grid is pre-filled with the incoming event attributes. In this case, we will alter them as follows:

• ReadingNo: Set the alias to ReadingId

• PumpId: Set the alias to AssetId, and order to 5

• ToRemove: Tick exclude

• Timestamp: Set the order to 25

Step 4: Results

Apply the changes, save the Data Stream and publish it.

Let's look at the Live Data View. Observe that the columns have been amended as follows:

• 'ReadingNo' is renamed to 'ReadingId'

• 'PumpId' is renamed to 'AssetId' and moved to the first position

• 'ToRemove' is removed

• 'Timestamp' is reordered from the end to before the temperature and flow rate

Files

File	Link	Security Key
Data Stream	Alter Attributes.xuc	C0mp|ex123

See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.