sqldf library R snippet error

KNIME Extensions
1

Hi,

I'm using sqldf R package to do some SQL queries on data. But when I do the same on the KNIME R snippet it returns me an error.

Code looks like this: 

install.packages("sqldf")
library(sqldf)

knime.out<-sqldf("SELECT knime.in$"Var1" FROM knime.in")

Error looks like this Error: unexpected symbol in "knime.out<-sqldf("SELECT knime.in$"Var1"

 

Tnx in advance.

2

Hmm, I played around with this a bit and I think that sqldf doesn't support the "."s in variable names.  Anyways, just out of curiosity, why do you need to run SQL on on KNIME data tables?  I imagine our column filters, row filters, groupby node and joiners should do the same thing, no?

Aaron

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.