Spotfire: How to write SQL in Data Functions?

I have been trying to write a SQL in TERR in Data Function Window of Spotfire. I have 2 tables in Spotfire (Teradata and Xls). I have to join the both on common columns (left) and then perform an aggregation. I pulled the column that i needed from the xls into the teraData Table via Insert>>Columns option. Now the sql that I want to run is: "SELECT prod,sub_prod,year,month,week,count(id)/avg(rate) cnt FROM ip1 group by prod,sub_prod,year,month,week"

When I just say op1 <- sqldf("SELECT prod,sub_prod,year,month,week,count(id)/avg(rate) cnt FROM ip1 group by prod,sub_prod,year,month,week") It throws an error. "TIBCO Spotfire Statistics Services returned an error: 'Error in library(sqldf) : there is no package called 'sqldf''"

What am I doing wrong?

Regards, Subro

Assuming you have statistic service installed for deployment...https://docs.tibco.com/products/tibco-spotfire-statistics-services-7-5-0

• Install the sqldf package: http://admin.viewcentral.com/events/uploads/TIBCO/Install-R-Packages_v65.pdf
• Restart the professional client
• Import the package in the Register Data Runctions window
• Run your script

This should resolve your error.