Integrate data and insert new columns

User: "elena2020chao"
elena2020chao
Banned
Updated by Jocelyn
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

Find more posts tagged with

AI Studio
Sort by:
1 - 3 of 31
    User: "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

    User: "elena2020chao"
    elena2020chao
    Banned
    OP

    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

    u.JPG
    User: "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

Quick Links