Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Use two attributes from dataset in loop/filter and use them in creating tables in Radoop nest
gLearn
I'm new to RapidMiner
I have a requirement where for the below dataset , I have to create tables using radoop operator where the name of the table should be saved with ID and Group names.
Dataset:
ID Group
-----------------------
1 Process
2 Subprocess
3 Operator
so my table should be saved in DB like below :
Table_1_Process
Table_2_Subprocess
Table_3_Operator
So,
I tried using Loop operator for ID, but I'm unable to connect the ID and Group column and get the exact match and create table, but rather it is checking with all the Group values and creating the tables like below:
Table_1_Process
Table_1_Subprocess
Table_1_Operator
Table_2_Process
Table_2_Subprocess
Table_2_Operator
Table_3_Process
Table_3_Subprocess
Table_3_Operator
Can you please help me with the loop, how to match both the ID and Group so that I can use them as macro value and easily use that macro to create table.
Thank you.
Find more posts tagged with
AI Studio
Accepted answers
All comments
kypexin
Hi
@gLearn
The simplest way to do that is to use
Generate Attribute
operator which will concatenate two values (ID and Table) in an ExampleSet and create the third attribute (Table name) in a desired format.
Attached is an XML of example process which generates exactly same dataset with 3 rows and then generates another column with table name in an expected format.
process.rmp
gLearn
Thank you , it worked
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups