Options

Integrate data and insert new columns

elena2020chaoelena2020chao Member Posts: 13
edited December 2018 in Help
Hello. I searched the forum but did not get it. I have two Excel files with the same number and number of columns. That row information is different. I want to merge them together and have a file. But I do not know how to do it? And I want to tag them after completing data clustering. Create a new column and put "yes or no" in that column. But do not know how For example, I want to say that the cluster has a "Yes" labels and the cluster has two "No" labels. Can anyone help me? Thank you so much for the help of my friends

Answers

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn

    Hi @elena2020chao,

     

    Can you share your dataset(s) in order we can better understand.

    Moreover can you, from your initial dataset(s), give an example of what you want to obtain ?

     

    Regards,

     

    Lionel

  • Options
    elena2020chaoelena2020chao Member Posts: 13

    my proccess< content is:
    Read Excel
    Append
    Write Excel
    Generate Attributes -->> if(cluster = "cluster1","yes",if(cluster = "cluster2","no","un"))


    but
    no meage data and show erorr
    "exception evaluation" error on '='

    please help me

    u.JPG

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn

    Hi @elena2020chao,

     

    You made a mistake in the syntax in the definition of your new attribute : 

    You have to define it like that : 

     

    if(cluster == "cluster1","yes",if(cluster == "cluster2","no","un"))

     

    Regards,

     

    Lionel

Sign In or Register to comment.