Integrate data and insert new columns

elena2020chao

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

lionelderkrikor

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

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

lionelderkrikor

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