how to modify attribute value in one exampleset based on some condition

Lei

I have two examplesets. I check if attribute value in second exampleset inside attribute in first exampleset. then I want to add some data to a new attribute in first exampleset based on comparsion


exampleset first:                                    exampleset second:
id   word   total                                      id   word    rate
1    cat       3                                         1    cat        2
2    dog      5                                         2    cattle     8
3    rat       4
4    pig       3
5    fish      6

compare word attribute of two examplesets, and find "cat" in both exampleset "word" attribute. so I want my result likes:

exampleset first:                                    
id   word   total   new_total  
1    cat       3          6                              
2    dog      5          5                            
3    rat       4          4
4    pig       3          3
5    fish      6          6

the "new_total" are calculated by "total"*"rate" if words exsit in both exampleset, otherwise copy "total" to "new_total".


Could someone tell me which operator I should use?
Thank you very much.

MartinLiebig

Hi,

looks like you want to left join the second on the first, replace mssings on the rate with 1 andthen use Generate Attributes to generate your product.

Best,

Martin