Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide Manuel d'utilisateur télécharger pdf (Page 131)

9 ● FactoryTalk Historian DataLink Function Reference

●

123

=PITimeDat("mytag",b1:b12,,"interpolated")

PITimeExpDat()

Retrieves FactoryTalk Historian point values based on an expression, and

corresponding to a specified array of time stamps, using the following

syntax:

PITimeExpDat(expression, timestamps, PIServer)

Arguments

Argument

Explanation

expression (string)

A FactoryTalk Historian calculation expression.

timestamps

(reference)

A reference to an array of time stamps in FactoryTalk Historian time

format (monotonically increasing or decreasing for FactoryTalk

Historian 2 servers).

PIServer (string)

The target FactoryTalk Historian server.

Returns

Sampled data. If the time stamps are in a single column, the data are

returned along a single column. If the time stamps are in a single row, the

data are returned along a single row.

Example:

The following calculates the square root of the value of the tag sinusoid

for the times located in cells B1 through B12 from the default FactoryTalk

Historian server:

=PITimeExpDat("sqr('sinusoid')",b1:b12,)

1 2 ... 126 127 128 129 130 131 132 133 134 135 136 ... 163 164

Pas de commentaire

Rockwell-automation FactoryTalk Historian SE DataLink 4.2 User Guide Manuel d'utilisateur Page 131