Integrate data and insert new columns

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

Answers

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    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

  • elena2020chao
    elena2020chao New Altair Community Member

    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

  • lionelderkrikor
    lionelderkrikor New Altair Community Member

    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

Categories