Use two attributes from dataset in loop/filter and use them in creating tables in Radoop nest

gLearn
gLearn New Altair Community Member
edited November 2024 in Community Q&A
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.
Tagged:

Answers

  • kypexin
    kypexin New Altair Community Member
    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.


  • gLearn
    gLearn New Altair Community Member
    Thank you , it worked