Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 129)

9
●
FactoryTalk Historian DataLink Function Reference
●
●
●
●
●
121
Time stamps are shown in column1 and values in column2. A Filtered
status is returned for values do not satisfy the filter condition in cell A1.
PIExpDat()
Retrieves FactoryTalk Historian point values based on an expression, using
the following syntax:
PIExpDat(expression, stime, etime, interval, outcode,
PIServer)
Arguments
Argument Explanation
expression (string) A FactoryTalk Historian calculation expression.
stime (string) The start time for the range of sampled values (in FactoryTalk
Historian time format).
etime (string) The end time (in FactoryTalk Historian time format).
interval (string) The interval between sampled values (in FactoryTalk Historian time
format).
outcode (integer) An output code to determine results placement, either 0, 1, 2, or 3.
PIServer (string) The target FactoryTalk Historian server.
Returns
Outcode Sampled Value Time stamp
0 output cell none
1 right column output cell
2 output cell none
3 row below output cell
An output code (page 104) of 2 transposes the output array that results
from an output code of 0 while an output code of 3 transposes the output
array that results from an output code of 1.