Options

Simple queries

sshildermansshilderman Member Posts: 9 Contributor II
edited November 2018 in Help
I'm all new to Rapidminer, and having troubles with basic stuff.
I want to make a query on two tables (example sets) at a time, and cross the data.

I can write a SQL statement, but i can't find a away to show it at the results page (if it's possible).

How can i do that both ways?

Thanks.

Answers

  • Options
    earmijoearmijo Member Posts: 270 Unicorn
    Use the operator JOIN.

    If you give me more details, I can be more specific.
  • Options
    sshildermansshilderman Member Posts: 9 Contributor II
    I'm using Join as you said.

    Is there a way to use the Execute SQL operator and show the result on Rapidminer? and keep working with the data?

    thanks.
  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,507 RM Data Scientist
    Hi,

    have you tried Read Database? You can write custom sql there as well.

    ~Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    sshildermansshilderman Member Posts: 9 Contributor II
    Didn't know the Read Database supports it.
    It is definitely what i needed.

    Thanks a lot!
Sign In or Register to comment.