This is an old revision of the document!


Samples

Captures table values over time into attributes of the timeframe.

This is used to capture a sequence of values that happen over time in a clear, consistent order.

For example, you can choose to sample a table of Temperature values every 5 seconds for 30 seconds. This will create 6 attributes in your final Capture, named Temperature_1, Temperature_2 etc, until Temperature_6. Each will be 5 seconds apart.

The system will forward-fill any missing data to ensure it is complete for AI or analytic use.

This deletes the table.

Parameters

NameDefaultMeaning
secondsThe number of seconds per sample
maxThe maximum number of samples
columnsThe specific columns to extract (optional)

If no columns are specified, all columns in the table are summarised.

Example

If the frame contains the following table of data…

AttributeValue
StartTime09:00AM
EndTime10:00AM
TimeMachine.SpeedMachine.VoltageMachine.Current
09:00AM000
09:10AM02403.2
09:20AM152401.5
09:30AM182401.5
09:40AM172401.5
09:50AM17.52401.5
{
   "type": "sample",
   "seconds": 600,
   "max": 4,
   "columns": ["Machine.Voltage"]
}

The final capture will have the following attributes…

AttributeValue
StartTime09:00AM
EndTime10:00AM
Machine.Voltage_10
Machine.Voltage_20
Machine.Voltage_315
Machine.Voltage_418