The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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.