Data Type Mapping


Data dimensions

TIBCO Spotfire data

S-PLUS / TIBCO Enterprise Runtime for R / R data

Value

Vector  of length 1 (list for timeDate)

Column

Vector (list for timeDate)

Data table

data.frame

Data types sent and received via data functions in S-PLUS / TIBCO Enterprise Runtime for R / R engines

TIBCO Spotfire data type

Class for TIBCO Enterprise Runtime for R and  R

Class for S-PLUS

Real

numeric

numeric

Integer

integer

integer

SingleReal

numeric

single

Currency

numeric (not supported in R)

(not supported in S-PLUS)

String

character encoded as UTF-8

character

DateTime

POSIXct with time zone UTC

timeDate with time zone GMT

Date

POSIXct with time zone UTC

timeDate with time zone GMT

Time

POSIXct with time zone UTC giving time on date 1/1/1970

timeDate with time zone GMT giving time on date 1/1/1960

Boolean

logical

logical

Binary

raw

raw

Support for invalid values

All numeric invalid values in TIBCO Spotfire are represented as NAs in the S-PLUS, TIBCO Enterprise Runtime for R,  and open-source R engines. There is no special support for invalid values of other types; they become valid default values in the S-PLUS, TIBCO Enterprise Runtime for R,  and open-source R engines.

Calling conventions for functions

The names of the data function input arguments must match the names of the S-PLUS, TIBCO Enterprise Runtime for R,  and open-source R  function arguments.

For functions that return only one value (not a list of values), the single data function output parameter will be matched to the value.

For functions returning a list of values, the data function output parameters must match the names of the list elements.

Sending and Receiving Data from SAS® and MATLAB®

When executing data functions via SAS and MATLAB scripts, the TIBCO Spotfire input and output data tables are converted to data types that these engines can process. See the TIBCO Spotfire Statistics Services - User's Guide for more details on the SAS and MATLAB data types used, and for information regarding limitations on data conversion.

 

Concerning R:

R is available under separate open source software license terms and is not part of TIBCO Spotfire.  As such, R is not within the scope of your license for TIBCO Spotfire. R is not supported, maintained, or warranted in any way by TIBCO Software Inc.  Download and use of R is solely at your own discretion and subject to the free open source license terms applicable to R.

See also:

What are Data Functions?

Name Encoding for Column Names Sent to Spotfire Statistics Services