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.
I want to combine multiple data.
Hello,
I started to learn rapid miner recently.
I want to combine multiple data. I import 10 excel files, so I want to combine these files into one. 'Join' operator connect only two files. It's annoying to connect one by one. Please tell me efficient method.
Sorry, I'm not good at English.
Thank you
I started to learn rapid miner recently.
I want to combine multiple data. I import 10 excel files, so I want to combine these files into one. 'Join' operator connect only two files. It's annoying to connect one by one. Please tell me efficient method.
Sorry, I'm not good at English.
Thank you
0
Best Answers
-
Pavithra_Rao Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 123 RM Data ScientistHi @furufuru
I would recommend using the 'Turbo Prep' feature in RapidMiner Studio to make it much easier to Join 10 excel files.
https://rapidminer.com/products/turbo-prep/
Cheers,
Pavithra1 -
yyhuang Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 RM Data ScientistHi @furufuru welcome to RapidMiner community.
The joining of 10 different data set is doable with "loop". I am listing step by step SUDO codes that might be useful- remember your 1st table, "remember" operator, name it Merged_Tab
- join your 1st and 2nd table with some keys, you will need "recall" to bring the 1st table and "remember" the joined results, name it the same Merged_Tab
- repeat step2 as you always have any updated Merged_Tab and a new table, keep joining the new tables
- finish up for all 10 tables
Hope it helps.
YY
1
Answers
Turbo Prep is useful. I will study to use Turbo Prep.
Thank you.
furufuru
I could understand your description.
Thank you.
furufuru