I don´t no how to join differents database with the same tittles or headlines

luis_garrido
luis_garrido New Altair Community Member
edited November 5 in Community Q&A

i have different list of clients with the same headlines, the thing is that the databases are huge! i have 13 databases with more than 450,000 observations ich..

 

how can i join them in one single table? 

 

thanks!

 

 

Tagged:

Answers

  • IngoRM
    IngoRM New Altair Community Member

    Hi,

     

    Ok, that seems to be something you could do with the "Join" operator.  Did you try to use it?  If yes, what is the specific problem you have?

     

    Cheers,

    Ingo

  • Telcontar120
    Telcontar120 New Altair Community Member

    If all the attributes are exactly the same (same names, same data type, etc.) then you could also use Append.

    But depending on whether you are running RapidMiner Studio locally, and the size/memory of your machine, this may be something that you are better off doing inside your database environment first.  Pulling millions of records into memory for merge operations is going to be a challenge for most desktops.  If you are using RapidMiner Server and have that class of hardware available, it is a different story.

     

     

Categories