Jump to content

R function runs fine in R Studio but throws error in Spotfire

Robert Lambert 2

Recommended Posts

I built and checked out a function in Rstudio

When i try to run it in Spotfire, as I use insert calculated column and insert the function I added (in Expression Functions), as I fill it in it throws this error (red exlamation point) and I cannot click ok to execute it...


TIBCO Enterprise Runtime for R returned and error: 'Error in marshallSpotfireOutputParameters(outputs, envir = marshallEn:object 'output' not found.





Link to comment
Share on other sites

You cannot run a R script in a calculated column.

To run a R/TERR script in Spotfire you need to create a data function.

The error looks like your script does not have an output object mapped to the parameters.

Check this link on how to create a data function:https://docs.tibco.com/pub/enterprise-runtime-for-R/latest/doc/html/TIB_terr_Documentation/GUID-483E3F38-77E8-4403-BDC2-EA1CD1FE514A.html

Link to comment
Share on other sites

Awesome thanks


But my function can have variable # args (x,y,...)  Throws following error message as I build the registered function input parameters list...


... does not comply with TIBCO Enterprise Runtime for R name standard.


How do I get around that


For now I tried to replace the ... with a fixed number of arguments.  The problem now is I register the function, then insert from library and hook up all the inputs from my table... its not clear how the output table name gets established... but I basically set all the input parameters to column property on the input handler, and selected the appropriate column.  on the output tab its not clear what to do... I want to name the output column ZOUT.  not sure how to do that or what item to pick in the output handler list... In any case, I cannot get the OK at bottom to be selectable no matter what I do... its greyed out.  I took a much simpler function I created and followed the same steps and that works fine, so not sure what I am missing with this more complicated R script.


How can I insert a screenshot into this thread





Link to comment
Share on other sites

In the Output tab under edit parameters when you set the output as new table you have the option to add table name. By default Spotfire takes the table name as output parameter name that you defined in your data function script.


You can define the column name in the script to get the output column to the value you want. I have added a screenshot of an example.




You can add a screenshot by clicking the media browser(should be on the right side) option in the chat and upload the image.





Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...