Simple queries

sshildermansshilderman Member Posts: 9 Contributor I
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: 270 Unicorn
    Use the operator JOIN.

    If you give me more details, I can be more specific.
  • sshildermansshilderman Member Posts: 9 Contributor I
    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,453 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 I
    Didn't know the Read Database supports it.
    It is definitely what i needed.

    Thanks a lot!
Sign In or Register to comment.