How to dynamically change real values to integer values for a data table that is generated from an R or TERR data frame via Spotfire data function.
Article ID: KB0072331
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All |
| Spotfire Desktop | All |
| Spotfire Enterprise Runtime for R - Server Edition | All |
Description
This article provides examples of how to dynamically change real values into integer values, for columns in a Spotfire data table that is generated from an R or TERR data frame via a Spotfire data function.
Environment
All supported environments
Resolution
The Spotfire data function will return integer columns in the TERR data frame to Spotfire as Integer columns in the data table. The following TERR expressions can be used to convert real numbers into integers before returning the data frame to Spotfire:
as.integer( trunc() )
as.integer( floor() )
as.integer( ceiling() )
as.integer()
These functions work the same way in TERR and in open-source R.
NOTE: Both in TERR and in open-source R, the trunc(), floor() and ceiling() functions return objects of class "numeric", which will become Real values in Spotfire. Wrapping calls to these functions in calls to as.integer() converts their results into "integer" values that will become Integer values in Spotfire.
The following are some example calls to those functions, along with the commands that open their help topics, using TERR 6.0.0:
pi
testVec <- c( pi, -pi )
testVec
as.integer( trunc(testVec) )
as.integer( floor(testVec) )
as.integer( ceiling(testVec) )
as.integer(testVec)
?trunc
?floor
?ceiling
?as.integer
=================================================
TIBCO Software Inc. Confidential Information
Copyright (C) 2011-2020 TIBCO Software Inc. ALL RIGHTS RESERVED
TIBCO Enterprise Runtime for R version 6.0.0 for Microsoft Windows 64-bit
Type 'help()' for help.
Type 'q()' to quit.
>
>
> pi
[1] 3.141593
>
>
> testVec <- c( pi, -pi )
>
>
> testVec
[1] 3.141593 -3.141593
>
>
> as.integer( trunc(testVec) )
[1] 3 -3
>
>
> as.integer( floor(testVec) )
[1] 3 -4
>
>
> as.integer( ceiling(testVec) )
[1] 4 -3
>
>
> as.integer(testVec)
[1] 3 -3
>
>
=================================================
as.integer( trunc() )
as.integer( floor() )
as.integer( ceiling() )
as.integer()
These functions work the same way in TERR and in open-source R.
NOTE: Both in TERR and in open-source R, the trunc(), floor() and ceiling() functions return objects of class "numeric", which will become Real values in Spotfire. Wrapping calls to these functions in calls to as.integer() converts their results into "integer" values that will become Integer values in Spotfire.
The following are some example calls to those functions, along with the commands that open their help topics, using TERR 6.0.0:
pi
testVec <- c( pi, -pi )
testVec
as.integer( trunc(testVec) )
as.integer( floor(testVec) )
as.integer( ceiling(testVec) )
as.integer(testVec)
?trunc
?floor
?ceiling
?as.integer
=================================================
TIBCO Software Inc. Confidential Information
Copyright (C) 2011-2020 TIBCO Software Inc. ALL RIGHTS RESERVED
TIBCO Enterprise Runtime for R version 6.0.0 for Microsoft Windows 64-bit
Type 'help()' for help.
Type 'q()' to quit.
>
>
> pi
[1] 3.141593
>
>
> testVec <- c( pi, -pi )
>
>
> testVec
[1] 3.141593 -3.141593
>
>
> as.integer( trunc(testVec) )
[1] 3 -3
>
>
> as.integer( floor(testVec) )
[1] 3 -4
>
>
> as.integer( ceiling(testVec) )
[1] 4 -3
>
>
> as.integer(testVec)
[1] 3 -3
>
>
=================================================
Issue/Introduction
How to dynamically change real values to integer values for a data table that is generated from an R or TERR data frame via Spotfire data function.
Additional Information
The help topics for these functions are opened by the following TERR commands:
?trunc
?floor
?ceiling
?as.integer
?trunc
?floor
?ceiling
?as.integer
Feedback
Yes
No
Powered by
