Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

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

  • earmijoearmijo Member Posts: 271 Unicorn
    Use the operator JOIN.

    If you give me more details, I can be more specific.
  • 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.
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,529 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
  • 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.