How to take unique rows based on two columns

Question

Mekala balaji 2018-7-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408972-how-to-take-unique-rows-based-on-two-columns

评论： Image Analyst 2018-7-8

Hi,

I have below previousDdata and currentData (cell matrix), and I want extract and add to currentData the unique rows based on column2 & column3(which does not exists in currentData) of previousData.

previousData: 
Date       PreName   PostName  score   rank 
2018-01-01   A         V         12     23
2018-01-01   H         Q         45     95
2018-01-02   B         K         10     36
currentData: 
Date       PreName   PostName  score   rank 
2018-01-01   A         V         12     23
2018-01-01   H         Q         45     95
2018-05-12   P         N         10     36
2018-06-14   X         G         10     36

for example: row3 (B & K), does not exists in currentData, so I will retain it from previousData. My desired output is:

result: 
Date       PreName   PostName  score   rank 
2018-01-01   A         V         12     23
2018-01-01   H         Q         45     95
2018-05-12   P         N         10     36
2018-06-14   X         G         10     36
2018-01-02   B         K         10     36