Blog Posts Process Management

How to Use SQL in Spotfire Data Functions

Blog: The Tibco Blog

SQL Statements can be used inside TERR in several ways. One of these is the open source R package sqldf, which can run SQL statements on R data frames. The user simply specifies an SQL statement in R using data frame names in place of table names. As a result, several things happen:

Check out this resource to learn more about sqldf.

Here’s an example illustrating SQL in Spotfire data functions in three steps:

1. Input data: A simple data table, which contains a brief description about quantity of fruits and vegetables, is loaded into Spotfire.

step_12. Using TERR tools > Package Management, the user can install sqldf R package.


3. The following script can be used to execute SQL statement and then return output as an out table.


You can view final results in Spotfire as only Fruits returned after SQL query execution.


To find out more about Spotfire and its innovative features, click here, and check out a free trial here.

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples