Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"Regarding SQL Query"

Hi,

I am newbie to RM. How to analyse an excel sheet data using SQL without connecting database. I tried it by using DatabaseExampleSource, but I think
there is no option available for excel in database_system paramater tab.Is there any option available for that.

Thanks,
Nancy

Find more posts tagged with

AI Studio

SQL

Accepted answers

All comments

land

Hi,
to my knowledge you cannot search Excel files using SQL with anyway. And to be honest: It doesn't make sense to me, too.
What exactly are you going to analyze with SQL?

Greetings,
Sebastian

keith

An easier approach might be to use ExcelExampleSource to read the Excel workbook. :-)

But if you really need to read the Excel file as a SQL source, you might try using the ODBC Bridge driver in DatabaseExampleSource. I think this will require that an ODBC data source be configured that points to the Excel file (e.g. using ODBC Data Source Administrator under Control Panel->Administrative Tools) . Once the ODBC data source is configured then you should be able to use the JDBC-ODBC Bridge driver in RapidMiner to connect. I haven't tried this myself though.

Keith